Text Import Wizard Excel

I am looking for information regarding a vb.net text import wizard similiar to the one that excel uses. I want to use it as a front end for aspose. I would appreciate any leads.

Thanks,
Bob

Hi Bob,

Currently Aspose.Excel doesn’t support text import feature as MS Excel. So you have to implement it by your own code.

In front end, you supply UI like text import wizard to your users. They can set options for text import. Then you write code to convert text to your expected cell data.

@bobm,
Aspose.Excel is discontinued now and is replaced by a new product Aspose.Cells which is far better in terms of performance and variety of features. This new product supports importing text files as follows:

TxtLoadOptions opts = new TxtLoadOptions();
opts.Separator = ',';
opts.HasFormula = true;

// Load your CSV file with formulas in a Workbook object
Workbook workbook = new Workbook(dataDir + "sample.csv", opts);

// You can also import your CSV file like this
// The code below is importing CSV file starting from cell D4
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Cells.ImportCSV(dataDir + "sample.csv", opts, 3, 3);

// Save your workbook in Xlsx format
workbook.Save(dataDir + "output_out.xlsx");

More details on this topic are available here:
Load or Import CSV file with Formulas

You may download the latest version of this new product here:
Aspose.Cells for .NET (Latest Version)

A ready to run solution can be downloaded here.