Removing hidded cloumns and rows from XLSX sheet

Neelsk · July 14, 2018, 8:04am

HI All
Looking at using Linx to covert Excel workbooks into apps.
Question.
Can Linx clean up a Xlsx mess with many hidden rows and columns?
Currently using MS Power Query.

Dawie_Botes · July 16, 2018, 6:08am

Hi Neelsk,

I’m going to write a quick example of how I whould do this. The idea is to let Linx read the one Excel file and only write over to a new excel file the fields that contains data.

Dawie

Neelsk · July 16, 2018, 6:45am

Thanks Davie.
I need to load the sheet into a MySQL and or NoSQL database.
Would in be possible in one step?

Dawie_Botes · July 16, 2018, 6:52am

Hi Neelsk,

Will change the solution a bit for that. It’s actually quite a bit easier to move it straight to a DB.

For the example I’m just going to create a DB Table in MSSQL, but you can use any.

Regards,
Dawie

Dawie_Botes · July 16, 2018, 7:37am

Hi Neelsk,

I’ve changed the Solution a bit to fit your requirement for the DB.

Please find attached. You’ll need to change the connection strings etc.

Regards,
DawieExcelRemoveBlanks.lsoz (14.3 KB)