Linx Main Linx Help

Removing hidded cloumns and rows from XLSX sheet


#1

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.


#2

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


#3

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


#4

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


#5

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)