Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2023-10-20 17:19:12

bici
Member
From: vancouver
Registered: 2004-02-24
Posts: 2,075
Website Mastodon

Display excel spreadsheet and CSS

Anyone have suggestions for how to best, and simply, display a responsive CSS styled .xls file in TxP articles. i.e. I want insert a spreadsheet in a few articles.

PS enjoy the Orionid meteor shower weekend


…. texted postive

Offline

#2 2023-10-21 06:23:20

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,012
Website GitHub Mastodon Twitter

Re: Display excel spreadsheet and CSS

Would this plugin by Stef be of use?


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#3 2023-10-23 01:18:14

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 3,081
Website

Re: Display excel spreadsheet and CSS

Depends…
First step would be to convert the .xls file to an HTML <table /> – probably… or maybe a definition list (<dl />) if the data set is simple. The plugin Yiannis linked to is most certainly your friend.

Once you have that, making it display “responsibly” really depends on the complexity of the generated data. Is it a simple table (no more than 3 or 4 columns, where there is no column header)? That is possible to render as a single column on small screen devices). On the other hand, for a complex table (many columns, and esp. if there is column header), forget it, changing the display very quickly becomes a hard to understand mess where all relationship between the information bits (each cell) is lost. In that case, you can’t do much better than what is done on the list panels in TXP admin:

<div  tabindex="0">
  <table>
…………
   </table> 
</div>

Styling:

div { max-width:100%; overflow: auto; }

Style the <table /> however you want. The@tabindex=0”@ on the div above makes it easily accessible (scrollable) for keyboard users.


Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern

Offline

#4 2023-10-23 02:59:47

bici
Member
From: vancouver
Registered: 2004-02-24
Posts: 2,075
Website Mastodon

Re: Display excel spreadsheet and CSS

thanks all. But this website rocks! CSS table Generator

I was able to get something up in 5 minutes.

It’s one of those tools that used to be easy to find, but nowadays it took me 4 days before I found it.
PS lots of useless websites that pretend to offer solutions only to send you down frustrating rabbit holes.


…. texted postive

Offline

Board footer

Powered by FluxBB