Read data by column #36
-
|
We are trying to read data by specific column, Can you please give us details on this. TIA |
Beta Was this translation helpful? Give feedback.
Replies: 3 comments 2 replies
-
|
Hi! Could you please attach a sample Excel file and describe what you'd like to achieve? |
Beta Was this translation helpful? Give feedback.
-
|
@AlexTimo , We have this sample need to get unique data for column B and C. If small file we can get all data by rows and filter it, but some files like it has 50 columns and 100K rows that time its taking huge time to read file. It will be help that we can read by column so we can make read data faster. Please let us know if any solutions. TIA |
Beta Was this translation helpful? Give feedback.
-
|
Hi @SreekanthMekala, do you have any further question or should I close this thread? |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for update @AlexTimo. We can close it |
Beta Was this translation helpful? Give feedback.
-
|
I've a done a test with 100K rows and 50 columns, it took about 2 min and 20 seconds to parse the file and find unique values in two columns. Since xlstream is optimized for maintaining low memory footprint, you may be better served by a library that loads the whole file into memory first. For example, the same task (finding unique values in two columns) took about 50 seconds when using SheetJS (xlsx package). |
Beta Was this translation helpful? Give feedback.
I've a done a test with 100K rows and 50 columns, it took about 2 min and 20 seconds to parse the file and find unique values in two columns. Since xlstream is optimized for maintaining low memory footprint, you may be better served by a library that loads the whole file into memory first. For example, the same task (finding unique values in two columns) took about 50 seconds when using SheetJS (xlsx package).