Export & Import data from Excel RRS feed

  • Question

  • User2091143711 posted

    Now I m exporting and importing data from excel via c#. In that export data as in the format of "Text (Tab delimited)(*.txt)" type with extension of ".xls" . Again i import this same excel , but i can't able to import. If i save this file as Workbook in excel with same extension of ".xls" , then import data, the data is imported.

    Why it is not imported in the format of "Text (Tab delimited)(*.txt)" type with extension of ".xls". How to solve this problem? reply any one.

    Tuesday, July 28, 2009 1:44 PM

All replies

  • User-4196158 posted

    If you export data in a tab separated format and rename it as .xls files, then try opening it with Excel, I'm sure it won't be able to open. What you mean is a .csv file.

    What code are you using for reading your tab separated .xls file? Please post a snippet.

    Tuesday, July 28, 2009 1:58 PM