Export to excel sheet wise
-
Hey people, Could somebody sujest a way to export a set of web pages to excel - a page a sheet. For single page exports i use the ContentType specifications. But im not able to export multiple pages. All pages come into a single sheet. I tried using Excel object, but as far as i could explore, it lets me to enter values to each cell which is almost impossible to do for a web page which contains data spread across many tables and tds (Un Structured). Moreover it consumes lots of time for execution. I also tried using OWCs 9.0 and 11.0, but msdn advises not to use it also it demands licensed office versions in client systems, that i cant guarantee. At last i tried to generate an XML document from the Response (HTML) string, to a XL schema valid xml. But converting tds with attributes to , really blows me off. Also child Tables are pieces i cant able to find a solution. Could somebody sujest a way for this problem.
-
Hey people, Could somebody sujest a way to export a set of web pages to excel - a page a sheet. For single page exports i use the ContentType specifications. But im not able to export multiple pages. All pages come into a single sheet. I tried using Excel object, but as far as i could explore, it lets me to enter values to each cell which is almost impossible to do for a web page which contains data spread across many tables and tds (Un Structured). Moreover it consumes lots of time for execution. I also tried using OWCs 9.0 and 11.0, but msdn advises not to use it also it demands licensed office versions in client systems, that i cant guarantee. At last i tried to generate an XML document from the Response (HTML) string, to a XL schema valid xml. But converting tds with attributes to , really blows me off. Also child Tables are pieces i cant able to find a solution. Could somebody sujest a way for this problem.
Hi, this will help you http://www.dotnet247.com/247reference/msgs/26/132455.aspx[^]
regards GV Ramana
-
Hi, this will help you http://www.dotnet247.com/247reference/msgs/26/132455.aspx[^]
regards GV Ramana
hi ramana, Thnx, for ur help, but if u go through my post, u can see i have already done this ContentType method, but the problem is it will come as a single sheet, what i need is that each of the page i select should come in different excel sheet, Please see if you could do anything in this regard.