Skip to main content

Posts

Showing posts from November, 2008

Rotate text in Web Generated Excel File

There are many reasons to generate Excel files from your website, mainly generating data reports. As far as I know there are a couple of ways to generate Excel file from your web server regardless the platform: - Component Server Side: There are several server-side components available to create excel files. Moreover, if you have MS Excel installed in your computer you can create excel files without third-party components. -Client Side: If there's Excel installed in the client machine, a client vbscript can generate the file you need. I am not sure if it works under Firefox and, running client-side scripts can create a security hole in your system. - XML Server Side. One nice feature of excel is that you can generate an excel file without the need of a component. That is, you generate an HTML-like document with the appropriate header and it will be available in Excel. Well, this is just an introduction, not the subject of this post. I will focus on XML server side Excel file, but y