tag:blogger.com,1999:blog-3280948321129906341.post7443236257740123765..comments2024-02-25T00:32:44.085-08:00Comments on john.livingston.tech: Create an Excel workbook from a DataSet using Open XML SDKjohn.livingstonhttp://www.blogger.com/profile/15046544302781486569noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-3280948321129906341.post-36383643323669239462014-03-01T02:38:35.230-08:002014-03-01T02:38:35.230-08:00How to freeze the header row of xls?How to freeze the header row of xls?Anonymoushttps://www.blogger.com/profile/12784534952676571041noreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-37869858206025321532013-05-02T23:55:09.332-07:002013-05-02T23:55:09.332-07:00This is great
Thanks!This is great<br />Thanks!Davidhttps://www.blogger.com/profile/13243750897714466000noreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-91678817145836761462013-04-05T04:27:55.324-07:002013-04-05T04:27:55.324-07:00Thanks John.
Thanks John.<br />Anonymoushttps://www.blogger.com/profile/05488285014434866174noreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-74532479566637247202013-03-31T20:33:56.947-07:002013-03-31T20:33:56.947-07:00Thanks John
Leaving the first purple line?Thanks John <br />Leaving the first purple line?@vdscauehttps://www.blogger.com/profile/06668299326496552874noreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-20875912477092900502012-07-17T12:43:16.693-07:002012-07-17T12:43:16.693-07:00I am using this code now on one of our production ...I am using this code now on one of our production intranet sites. and the <br /><br />writer.PasteDataTable(ds.Tables[i], "A2", style); <br /><br />call is very slow for large data tables > 1000 rows. <br /><br />I even tried walking through each row and cell and using PasteText() instead, but thats slow also <br /><br />is this slow behavior to be expected?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-11316111183214987092012-06-21T11:09:35.522-07:002012-06-21T11:09:35.522-07:00Outstanding John.Outstanding John.Jayanthhttp://google.comnoreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-91076660666345245432012-06-17T14:21:44.935-07:002012-06-17T14:21:44.935-07:00really helped, thanx a lot dudereally helped, thanx a lot dudemichalhainchttps://www.blogger.com/profile/00500521344903110657noreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-41187216375295530032012-01-09T15:00:23.848-08:002012-01-09T15:00:23.848-08:00Thanks a million!Thanks a million!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-53748504962888045322011-01-25T12:50:08.189-08:002011-01-25T12:50:08.189-08:00No, I have not, but I'd be willing to bet you ...No, I have not, but I'd be willing to bet you can use the same SDK.john.livingstonhttps://www.blogger.com/profile/15046544302781486569noreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-26135783887969447252011-01-20T12:35:52.832-08:002011-01-20T12:35:52.832-08:00Thanks for the code John. Have you done the revers...Thanks for the code John. Have you done the reverse, take a memory stream with an Excel and create a dataset?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-82325689130522302742010-10-28T08:46:10.829-07:002010-10-28T08:46:10.829-07:00Not entirely sure...I'd definitely check out t...Not entirely sure...I'd definitely check out the Open XML SDK to see if they have anything.john.livingstonhttps://www.blogger.com/profile/15046544302781486569noreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-31040070570664616472010-10-12T10:43:53.078-07:002010-10-12T10:43:53.078-07:00How can you format the style of the worksheet and ...How can you format the style of the worksheet and freeze the top row?David Coxseyhttp://www.twitter.com/aptivadavenoreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-91061897325693584772010-10-08T01:35:35.499-07:002010-10-08T01:35:35.499-07:00Thanx for this awesome snippet! happy coding :)Thanx for this awesome snippet! happy coding :)Jason Smithhttps://www.blogger.com/profile/00886384757290796927noreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-25888907363141368022010-06-29T13:17:52.094-07:002010-06-29T13:17:52.094-07:00Wow, that is pretty horrendous. I have only used i...Wow, that is pretty horrendous. I have only used it for smaller datasets and it worked fine. If you are just using a DataTable, you may consider CSV instead. I needed a separate tab created for each DataTable in the DataSet in this case.john.livingstonhttps://www.blogger.com/profile/15046544302781486569noreply@blogger.comtag:blogger.com,1999:blog-3280948321129906341.post-46529843679495425162010-06-29T13:00:13.329-07:002010-06-29T13:00:13.329-07:00Thanks for the tutorial, but is it me or is it rea...Thanks for the tutorial, but is it me or is it really slow for large tables? For example, a 1-column, 120K-row table takes over an hour to convert on my machine. Is that to be expected? Here's the test code:<br /><br /> DataTable table = new DataTable();<br /> table.Columns.Add("Col_ID", typeof(Int32));<br /> table.Columns.Add("Col_Name", typeof(string));<br /> for (int x = 0; x <= 120000; x++)<br /> {<br /> DataRow dr = table.NewRow();<br /> dr["Col_ID"] = x;<br /> dr["Col_Name"] = "Data" + x.ToString();<br /> table.Rows.Add(dr);<br /> }<br /><br /> DataSet dataSet = new DataSet();<br /> dataSet.Tables.Add(table);<br /> MemoryStream memoryStream = ExcelUtility.GetStreamFromDataSet(dataSet);Unknownhttps://www.blogger.com/profile/06039400996222781505noreply@blogger.com