TongsasTong

Results 6 comments of TongsasTong

man page outdated

Hi, the option [--include-hidden-rows] to export all rows (not only filtered rows) is not default as Excel does when exporting XLSX to CSV file. Anyway, thanks again for this option...

"need to escape but no escapechar set"

I agree on the escape character parameter. Also, I am having this error because I use option QUOTE='none' on a file containing double quotes values (for inches, for seconds, or...

Function only reading filtered rows. How do I read all rows from a sheet?

Hello, I have just experimented it also. Is there a way/option that XLSX2CSV would read all rows of a sheet ?

Function only reading filtered rows. How do I read all rows from a sheet?

In the attached file, ColumnA is filtering rows only showing 'A' value in ColumnA (not showing the rows beginning with 'B' value) The xlsx2csv would only convert the visible rows,...

Function only reading filtered rows. How do I read all rows from a sheet?

> Looks like dilshod has fixed the issue. I downloaded the xlsx2csvc.py file in the repository and replaced the old file in my local machine with this new one. I...

Function only reading filtered rows. How do I read all rows from a sheet?

> I think `skip_hidden_rows=False` should be the default. Nobody expects filtered rows to be removed when reading an Excel. Yes, also, this is the default beahvior of excel when saviong...