1
Converter File Excel to txt file
Question asked by Manh Tran Van - 9/4/2017 at 8:00 PM
Answered
I want to convert from Excel file to txt file.
I did the following: convert excel file into html file then converted to plain text but time too long.
If I convert from excel file to pdf file and then convert to plain text, I lose the space between the lines.
Is there a faster way to convert without losing the space?

Currently I have tried using:
Step 1: convert file excel to html file
step 2: convert all file html to plain text
step 3: read text from plain text
But the processing speed is very slow ( >5 minute )

1 Reply

Reply to Thread
0
Cem Alacayir Replied
Employee Post Marked As Answer
You can directly convert to spreadsheet text formats:
 
Csv - Comma Separated Values File.
Tsv - Tab Separated Values File.
Dif  - Data Interchange Format.
 
If you have a lot of sheets, do you need to convert all sheets? 
Because you can choose sheets by passing input options to the Convert method:
 
new SpreadsheetInputOptions
{
    OutputSheetRange = new SheetRange("active")
};
 
The range is specified as a string in the following forms or combination thereof:
5
single value
1,2,3,4,5
sequence of values
1-5
closed range
-5
open range (converted to a sequence from 1 to 5)
1-
open range (converted to a sequence from 1 to final sheet)
all
keyword representing all sheet numbers.
odd
keyword representing odd sheet numbers.
even
keyword representing even sheet numbers.
active
keyword representing the active sheet number.
visible
keyword representing visible sheet numbers.
 
The value delimiter can be either ',' or ';' and the range separator can be either '-' or ':'. Whitespace is permitted at any point in the input.
Any elements of the sequence that contain non-digit, non-whitespace, or non-separator characters or that are empty are ignored.

Reply to Thread