tag:blogger.com,1999:blog-11216446.post1483720074478571841..comments2023-02-22T16:56:33.386+01:00Comments on Modern software design: C# ExcelWriter classSerhiy Perevoznykhttp://www.blogger.com/profile/05054587701401425172noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-11216446.post-5641908071402589622013-02-13T12:53:40.663+01:002013-02-13T12:53:40.663+01:00Hi,
On my ASP.Net Production Server, there is no ...Hi,<br /><br />On my ASP.Net Production Server, there is no MS-Office but for working with Excel (Like Reading and Exporting textual Table) we have installed AccessDatabaseEngine_x64.exe .<br /><br />Now While Exporting textual Table we also want to export dynamic image formed by MS-Chart on .aspx page.<br /><br />Paralelly we can not use Microsoft.Office.Interop.Excel.dll as we do not have installed MS-Office on Production Server.<br /><br />So how we can export such type of dynamic MS-Chart image with data only in Excel ?<br /><br />Thanks in Advance<br /><br />Rajesh SinghRajesh Kumar Singhhttps://www.blogger.com/profile/16450828656756541909noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-34631021859255691302011-10-04T12:27:15.672+02:002011-10-04T12:27:15.672+02:00Check the second part of my article: http://delphi...Check the second part of my article: http://delphi32.blogspot.com/2011/06/generate-excel-files-without-using.html<br />There is updated code availableSerhiy Perevoznykhttps://www.blogger.com/profile/05054587701401425172noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-73191905557850403192011-10-03T23:12:34.567+02:002011-10-03T23:12:34.567+02:00Big thanks to you. Does this code support unicode...Big thanks to you. Does this code support unicode characters while writing it in excel file? I have seen that your code uses default encoding and some places ASCII and I have replaced that with UTF-8 but still it doesn't write unicode characters in excel file. any thoughts on that?Shailesh Patelhttps://www.blogger.com/profile/15688186733107059575noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-89601109071492237512011-08-25T12:04:11.057+02:002011-08-25T12:04:11.057+02:00This class does not support formulas, sorry. If yo...This class does not support formulas, sorry. If you need it you have to find a more advanced exel generator (there are plenty of freeware libraries for it)Serhiy Perevoznykhttps://www.blogger.com/profile/05054587701401425172noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-45436214654926523782011-08-22T11:23:15.835+02:002011-08-22T11:23:15.835+02:00If I try to use in a cell a formula like "=a1...If I try to use in a cell a formula like "=a1+a2" then I don't get the result in Excel but the exact text I meant as a formula. How can I tell to the cell to calculate that? Thanks.Pacohttps://www.blogger.com/profile/12518372001287284117noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-37589084779002070752011-04-11T22:09:55.063+02:002011-04-11T22:09:55.063+02:00Good One. But opening the file in office 2007 and ...Good One. But opening the file in office 2007 and saving it back throws an error saying "it cannot be saved in the current format. Click OK to save in the latest format". Are we missing something in the header, I mean BOF.Unknownhttps://www.blogger.com/profile/11793090498419487475noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-79247899194384180992009-11-05T12:28:26.334+01:002009-11-05T12:28:26.334+01:00As you see the name of the class is "ExcelWri...As you see the name of the class is "ExcelWriter", so it's designed for writing files, not reading. In case if you have to read one, you can easy find a lot of freeware alternatives, on sourceforge, for exampleSerhiy Perevoznykhttps://www.blogger.com/profile/05054587701401425172noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-55115858591041410522009-11-04T21:03:34.697+01:002009-11-04T21:03:34.697+01:00I need to append to an existing excel, this class ...I need to append to an existing excel, this class overwrite all and let only de last element. Can you help me?<br />My e-mail is wefaamigo@hotmail.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-11216446.post-18209706297109082422009-05-17T21:56:00.000+02:002009-05-17T21:56:00.000+02:00This format does not support 2 worksheets. It can ...This format does not support 2 worksheets. It can do only what it can do. If something is not implemented in this library - it will be not implemented in the future as well. So if you need long strings, colors, formatting, worksheets, etc... - this library is not for you.<br />There are many big and powerful libraries that can do all the things you needed. Some of them are free.<br />The main purpose of ExcelWriter to make it "small and simple" and I want to keep it this waySerhiy Perevoznykhttps://www.blogger.com/profile/05054587701401425172noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-33830420531646003812009-05-17T21:50:00.000+02:002009-05-17T21:50:00.000+02:00I received few times the question about inserting ...I received few times the question about inserting the long text into one cell. <br />OK, with this library the max. size of the text is 255 characters as it uses old and simple BIFF format for storing the file. <br />Also I am not sure what the practical usage of writing 4000 characters in one cell?Serhiy Perevoznykhttps://www.blogger.com/profile/05054587701401425172noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-12551034823570129922009-05-05T20:30:00.000+02:002009-05-05T20:30:00.000+02:00This class can create only files with one workshee...This class can create only files with one worksheet, but I can recommend you another freeware library: http://code.google.com/p/excellibrarySerhiy Perevoznykhttps://www.blogger.com/profile/05054587701401425172noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-84803968743794980712009-05-05T16:15:00.000+02:002009-05-05T16:15:00.000+02:00Great job, I need create a file with two worksheet...Great job, I need create a file with two worksheets.<br /><br />Can you help me?Rafael Araujohttps://www.blogger.com/profile/15349675573355604944noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-651529940431878072009-03-25T21:18:00.000+01:002009-03-25T21:18:00.000+01:00How long is your text?How long is your text?Serhiy Perevoznykhttps://www.blogger.com/profile/05054587701401425172noreply@blogger.comtag:blogger.com,1999:blog-11216446.post-3238425039543206372009-03-10T17:30:00.000+01:002009-03-10T17:30:00.000+01:00I have a probleme to insert long text. The cell is...I have a probleme to insert long text. The cell is empty.<BR/><BR/>Can you help me ? <BR/><BR/>thanksUnknownhttps://www.blogger.com/profile/08913259948862892793noreply@blogger.com