how to get excel data as xml in c# code

hi i want to pass axcel sheet as xml to my store procedure..i was doing this by getting values in data table and then convetring that data table to exml..but i found when when i add a line at the end of sheet and then delete that ..even than when my sheet is loaded in data table it gives me blank rows at end which cause error in my case.i want to avoid that error.

so want to know some easy and direct way to convert excel to xml or some way to avoid those blank lines.

Re: how to get excel data as xml in c# code

Refer this post: http://forums.asp.net/t/1598497.aspx/1

Re: how to get excel data as xml in c# code

http://forums.asp.net/t/1448348.aspx/1

http://www.codeproject.com/Articles/10581/Convert-Excel-to-XML-file-XML-Schema-and-validate

Re: how to get excel data as xml in c# code

can't i add criteria here when selecting from excel sheet

select * from [Sheet1$] ??

i dont want to select every thing from excel sheet.i want to apply a check like if column one value is empty then skip that

is something like this is possible here??

Re: how to get excel data as xml in c# code

shumailaAjk
but i found when when i add a line at the end of sheet and then delete that ..even than when my sheet is loaded in data table it gives me blank rows at end which cause error in my case.i want to avoid that error.

When do you do thatDo you mean you do that after make a connection to the Excel file successfully and you change the excel file

Re: how to get excel data as xml in c# code

NO this was happining when i update my excel sheet supose i add two more records first save that

then i delete those two records and save my excel sheet..now when i was trying to upload that sheet it gives two empty lines at the end

those empty lines were creating problem for me.now i manage this by changing my query like this

select * from [Sheet1$] where sap_id is not null

so now i m not facing that issue.:-)

Re: how to get excel data as xml in c# code

shumailaAjk

i add two more records first save that

then i delete those two records and save my excel sheet..now when i was trying to upload that sheet it gives two empty lines at the end

those empty lines were creating problem for me.now i manage this by changing my query like this

select * from [Sheet1$] where sap_id is not null

So you mean this happens when you

1upload an original excel file onto Server

2Add rows

3Delete rows

4Read them outand found two empty rows

Re: how to get excel data as xml in c# code

no i was adding and deleting before uploding... but still it was picking some empty rows at the end.

Re: how to get excel data as xml in c# code

shumailaAjk

no i was adding and deleting before uploding... but still it was picking some empty rows at the end.

That's a little strangeWellyou can check whether your string.IsNullOrEmpty(DataTable.Rows[index][Field-index])If yesdelete the whole rowafter doing this and submit:-)

Re: how to get excel data as xml in c# code

:-) it is really strange.but its really hapening. thanks for solution