Import Excel Format on Asp.Net C#

Question

Hi everyone How Can i import excel document to datatable like below format excel table format i`m using to # character seperate every part. #CODE-1 A B C D E Column1 Value Value Value Value Value column2 Value Value Value Value Value Column3 Value Value Value Value Value column4 Value Value Value Value Value Column5 Value Value Value Value Value #CODE-2 Q W E R T Column1 Value Value Value Value Value column2 Value Value Value Value Value Column3 Value Value Value Value Value column4 Value Value Value Value Value Column5 Value Value Value Value Value Column6 Value Value Value Value Value #CODE-3 A S F H V Column1 Value Value Value Value Value column2 Value Value Value Value Value Column3 Value Value Value Value Value after import to datatble datatable like below CODE CAT TYPE VAL CODE-1 A Column1 Valuue CODE-1 A Column2 Valuue CODE-1 A Column3 Valuue CODE-1 A Column4 Valuue CODE-1 A Column5 Valuue CODE-1 B Column1 Valuue CODE-1 B Column2 Valuue CODE-1 B Column3 Valuue CODE-1 B Column4 Valuue CODE-1 B Column5 Valuue CODE-1 C Column1 Valuue CODE-1 C Column2 Valuue CODE-1 C Column3 Valuue CODE-1 C Column4 Valuue CODE-1 C Column5 Valuue CODE-1 D Column1 Valuue CODE-1 D Column2 Valuue CODE-1 D Column3 Valuue CODE-1 D Column4 Valuue CODE-1 D Column5 Valuue CODE-1 E Column1 Valuue CODE-1 E Column2 Valuue CODE-1 E Column3 Valuue CODE-1 E Column4 Valuue CODE-1 E Column5 Valuue Anybody Have an any idea

Vinay Singh · Answer

By converting row into column. you can acchive the task http://www.aspdotnet-suresh.com/2012/09/how-to-convert-rows-to-columns-in-sql.html

alice yang · Answer

Hi Check the following link: Import data from Excel to Datatable: http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html