The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Setting column widths in excel using html, First post :)
Jimjongil
post 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
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
pandy
post 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.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Jimjongil
post 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
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Darin McGrew
post 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



QUOTE(Jimjongil @ Aug 15 2020, 02:02 AM) *
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.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
pandy
post 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.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 29th March 2024 - 08:48 AM