G Guest Nov 5, 2007 #1 In my application my requirement is i have one excel file sheet, i want to convert that excel file to xml file?
In my application my requirement is i have one excel file sheet, i want to convert that excel file to xml file?
S sloan Nov 5, 2007 #2 Check these 2 entries: http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!148.entry http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!119.entry Start with the second link , then go to the first one. public class ExcelXMLConverter will give you "excel xml". the first KB will show you how to convert it to "more friendly" xml if need be. Having said that, you need to know that it isn't recommended to use excel object library objects on the IIS server. Another method is to use LoadDataSet against an excel file, and then use the ds.WriteXml() method. It depends on what you're after. http://support.microsoft.com/kb/306572
Check these 2 entries: http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!148.entry http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!119.entry Start with the second link , then go to the first one. public class ExcelXMLConverter will give you "excel xml". the first KB will show you how to convert it to "more friendly" xml if need be. Having said that, you need to know that it isn't recommended to use excel object library objects on the IIS server. Another method is to use LoadDataSet against an excel file, and then use the ds.WriteXml() method. It depends on what you're after. http://support.microsoft.com/kb/306572
M Mark Rae [MVP] Nov 5, 2007 #3 http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!148.entry http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!119.entry Click to expand... Having said that, you need to know that it isn't recommended to use excel object library objects on the IIS server. Click to expand... Not recommended, and not supported, because of the serious risks involved - please don't advise anyone to use server-side Office automation...
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!148.entry http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!119.entry Click to expand... Having said that, you need to know that it isn't recommended to use excel object library objects on the IIS server. Click to expand... Not recommended, and not supported, because of the serious risks involved - please don't advise anyone to use server-side Office automation...
