B4J Question Suggestions about importing a .tsv file into Excel

[B4JExplorer]

Hi,

I'd like to convert a VBScript app that I wrote, which imports a tab-delimited file into Excel, and performs all sorts of formatting functions.

I used the B4J Excel library - forgot what it was called - sometime back. No problem with that.


My question is how should I approach the import? Just create a spreadsheet, parse out each line from the tsv file, and proceed from there?

The VBScript is working perfectly, and has been in production for almost a year. The problem is that it has a dependence on Excel itself being present, and I'd like to generate the excel file without that requirement.

My only question is the Import part of the equation.

 

[Erel]

Using the old Excel library is a big mistake.

You should use XLUtils.

You can read TSV files with StringUtils.LoadCSV or CSVParser class.

 

[B4JExplorer]

No problem, I'll take a look at the more recent utils.

So we'll use the standard parsing routines?

Ok, thanks. I was asking, in case there was a parent import function already written which called its own parsing functions internally. Something like Excel's OpenText() function.