Link to home
Start Free TrialLog in
Avatar of RIAS
RIASFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

If speed is an issue, you only have one option IMO

I have done various document automation processes and GemBox Spreadsheet is the fastest library I have found.
https://www.gemboxsoftware.com/spreadsheet
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.
Avatar of RIAS

ASKER

Thanks,Any vb.net code please , appreciate it
Avatar of RIAS

ASKER

Cannot use any third party
ASKER CERTIFIED SOLUTION
Avatar of Misha
Misha
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RIAS

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