Cell Value not the same as uploaded excel

Hello, I have this excel format gsagsa.png

but why after i upload the file,  and i use this code:

 var temp = sheet.Range["B2"].Cells[0].Value; //this contain null or ""

but  sheet.Range["A2"].Cells[0].Value; //contain /tOrigindoc. 

then  sheet.Range["A2"].Cells[0].Value; //contain /tItem/tGI Date/t

B2 become A2,  and it become /tOriginDoc.

and the header column become merged in one column with /t/t/t/t/t

as image below

asassa.png

its like everything is merged into one column and there is \t on it,, this is hard for me to manipulate data,, any correction from you guys? please help thanks


1 Reply

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team March 9, 2022 09:44 AM UTC

Hi Bernadus, 

Greetings from Syncfusion. 

We request you to share the Excel document you are using at your end, which will be helpful for us in investigating the query and provide prompt solution at the earliest. 

Regards, 
Keerthi. 


Loader.
Up arrow icon