RIAS
asked on
excel sheet
Hi,
I am using vb.net desktop version, need to convert a excel sheet to csv.
Need to calculate the used range of excel and convert it into comma seperated csv.
***Please note speed is an issue here, if you suggest any code with high performance it will be appreciated the most.
Thanks
I am using vb.net desktop version, need to convert a excel sheet to csv.
Need to calculate the used range of excel and convert it into comma seperated csv.
***Please note speed is an issue here, if you suggest any code with high performance it will be appreciated the most.
Thanks
GemBox is good library,
But in some cases GemBox can be not free. Also you can use NPOI. It is free low-level api to work with excel.
But in some cases GemBox can be not free. Also you can use NPOI. It is free low-level api to work with excel.
ASKER
Thanks,Any vb.net code please , appreciate it
ASKER
Cannot use any third party
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
Glad to help you!
In vain you refuse good libraries. Many actions are already made for you in this lybraries.Not only do libraries make it easier, GemBox does not use Office so you do not need licenses and it is 20 times faster than Office automation
I have done various document automation processes and GemBox Spreadsheet is the fastest library I have found.
https://www.gemboxsoftware.com/spreadsheet