Greetings
Dear members, I've been checking out on internet, however, i didn't a single similar question, so i thought to ask it, may come handy for someone else, so here i go:
I have this giant excel files with 2 columns and +800,000 rows, the process is like this:
I am Filtering based on the second column(so there are many similar data on second columns), then after filter, i copy the first column and paste it on a notepad file(.txt) and change its name to second's column filter.
[Summery]
Input: Excel File
Output: multiple Notepad Files .txt
if i do this by hand would take hours and hours, so i thought maybe you can point me into a right direction, then rest i do myself.
Thank you in advance,
Alex SmithPosted Sep 2, 2015, 4:40 AM
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"..\ExceltoTxt.xls");
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToFile("ExceltoTxt.txt", " ", Encoding.UTF8);
Kip HackmanPosted Jun 22, 2023, 6:17 PM
I know this is an older post, but for those still looking for this functionality, you can use the LEADTOOLS Document SDK technology in your application.
https://www.leadtools.com/sdk/products/document
You can leverage the DocumentConverter class, to convert Excel files to TXT files.
Here is some sample code:
Rajeesh MenothPosted Sep 2, 2015, 6:37 AM
Masoud APosted Aug 26, 2015, 6:35 PM
Munesh SharmaPosted Aug 26, 2015, 12:02 AM
Karthikeyan KPosted Aug 25, 2015, 11:27 PM
Kindly accept answer
Karthikeyan K