tags:

views:

18

answers:

0
+1  Q: 

how to convert/import/create a CSV file to excel (xlsx) using C# forms

Hi guys,

I am trying to convert CSV file to MS Excel file. one of the issue, is that my CSV file , which I am getting from client, is not well formed. I tried to parse it with different approach but none of them end up with expected results. therefore I had to manually open the CSV file in Excel and save it as .xlsx and then use it for data import. But I want automate this change. i.e. an application which I give CSV file path and in response it generates a proper .xlsx file.

Thanks

related questions

C# Exception Handling continue on error
Exporting tab-delimited files in SSRS 2005
How can I join a list into a string (caveat)?
When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
Looking for tool to generate random CSV data
csv api for java
in rails, how to return records as a csv file
Import *variable record length* CSV file using SSIS
asp.net Convert CSV string to string[]
What's the best way to extract table content from a group of HTML files?
How do I save each sheet in an Excel workbook to separate CSV files with a macro?
Program for working with large CSV Files
How do I best generate a CSV (comma-delimited text file) for download with ASP.NET?
SSIS: Adding a constant column value when doing a CSV to SQL conversion
Java code to import CSV into Access
Parsing XML using unix terminal
CSV (or sheet in XLS) to SQL create (and insert) statements with .Net?
Generate Insert SQL statements from a csv file
Split a string ignoring quoted sections
FileHelpers performance
CSV string handling
What is a good web-based Grid that accepts Excel clipboard data?
CSV File Imports in .Net
How to export data from SQL Server 2005 to MySQL
Converting CSV File to XML in Java