Import Selected CSV file into New Excel file in user defined order

Question

I would like to ask for your help!!

I'm trying to import CSV file into New Excel file, User will give the input to select which CSV file, and program should import purticular data into new excel file and data should be in user defined order.

So guide me to choose correct platform or language to do it. my sample csv

and my expected output is

Time string will be Row headers, VarName will be Column headers.

varvalue will be in main data

Hi, I've gone with macro programs to read and write(customized) in new workbook excel. your links are good to read.. — RJ10, Sep 22 '15 at 06:04

score 3 · Accepted Answer · edited May 23 '17 at 11:59

There are many ways to do this. One of flexible ways is:

Create a model class for your data. (Each record of your csv file will be an instance of your model)
Create a RDLC report that represent your data in your desired layout and format. There you can arrange your data as in rows, columns , pivots, ...
Read data from your csv file and fill in List and pass it as data source to your report.
Export your report to Excel (and even other supported file formats like .doc, .pdf)

Additional resources:

Import Selected CSV file into New Excel file in user defined order

1 Answers1