Setting column widths in excel using html, First post :) |
Setting column widths in excel using html, First post :) |
Jimjongil |
Aug 15 2020, 05:02 AM
Post
#1
|
Group: Members Posts: 2 Joined: 15-August 20 Member No.: 27,494 |
First post, so i hope i've posted it in the right place!
I'm currently building tables in excel and exporting as CSV to upload to a website. When uploaded the columns are fitting the data inside of the table rather than carrying over the excel formatting. I need to be able to adjust column sizes so that they will carry over when uploaded onto the webpage. Any help would be greatly appreciated. James |
pandy |
Aug 15 2020, 05:33 AM
Post
#2
|
🌟Computer says no🌟 Group: WDG Moderators Posts: 20,716 Joined: 9-August 06 Member No.: 6 |
Don't follow. Have you already got the data into a HTML table?
Anyhow, make whatever you use to convert the data from CSV to a HTML table to also add the desired widths to the cells in the top row. Could be TD or TH, doesn't matter. https://htmlhelp.com/reference/html40/tables/td.html Alternatively add IDs to those cells and set the width with CSS. |
Jimjongil |
Aug 15 2020, 08:55 AM
Post
#3
|
Group: Members Posts: 2 Joined: 15-August 20 Member No.: 27,494 |
No I haven't yet converted the table into HTML, will give it a try and let you know how i get on.
Thanks for the help |
Darin McGrew |
Aug 15 2020, 10:01 AM
Post
#4
|
WDG Member Group: Root Admin Posts: 8,365 Joined: 4-August 06 From: Mountain View, CA Member No.: 3 |
I'm currently building tables in excel and exporting as CSV to upload to a website. When uploaded the columns are fitting the data inside of the table rather than carrying over the excel formatting. I don't think CSV supports formatting in any way. It's just data, row by row by row, with column values separated by commas. |
pandy |
Aug 15 2020, 10:14 AM
Post
#5
|
🌟Computer says no🌟 Group: WDG Moderators Posts: 20,716 Joined: 9-August 06 Member No.: 6 |
Surely a server side language must be able to transform that to a HTML table? If it doesn't need to happen on the server it can basically be done with Find & Replace.
|
Lo-Fi Version | Time is now: 29th March 2024 - 08:48 AM |