Freeto_India
New Coder
Hi All,
I have
2 -> .XLS files (with header),
1 -> .XLSX file and
1 -> .XLSX file (password protected)
I have to read these files optimally and create respective .CSV files
- What would be the best optimized approach?
- What are the necessary libraries required? Can one library solve this or we need different libraries for specific type of file?
- Can you share sample codes?
- There should be no loss of data.
- There is HEADER in file(as it is a reporting file) which has content to be extracted from.
- If there are extra empty columns then I want to exclude them in CSV.
- If there are empty cells then it should be blank (eg :- xyz,,abc),
NO space or any other value(eg :- xyz, ,abc).
Please let me know if more information is required.
I have
2 -> .XLS files (with header),
1 -> .XLSX file and
1 -> .XLSX file (password protected)
I have to read these files optimally and create respective .CSV files
- What would be the best optimized approach?
- What are the necessary libraries required? Can one library solve this or we need different libraries for specific type of file?
- Can you share sample codes?
- There should be no loss of data.
- There is HEADER in file(as it is a reporting file) which has content to be extracted from.
- If there are extra empty columns then I want to exclude them in CSV.
- If there are empty cells then it should be blank (eg :- xyz,,abc),
NO space or any other value(eg :- xyz, ,abc).
Please let me know if more information is required.