Member Avatar for neclark2

I'm currently working on a simple feature to extend a dynamically generated html table (from a database) by giving an option to view it as an excel document. This has not been a problem as it is very simple to just set the content-type to application/msexcel so that the table is interpreted as an excel document. My problem is that by default excel does not format the width of each column in accordance with the piece of data within that has the largest width. As a result, the data is all smashed together and not very pleasing to the eye. Is there a way to specify that this kind of formating should take place (like with html tables)?

thanks

  • 2 Contributors
  • 1 Reply
  • 66 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by R0bb0b
Member Avatar for R0bb0b

You can use html tables and colspan and rowspan define the number cells. width doesn't work.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.