Hello,

Is there a good way to display spreadsheet data in XOOPS?

I am developing a website using XOOPS2 and I have data that I want to share with registered users. The data is currently in a spreadsheet made in MS Excel (from office 97). I saved the spreadsheet as a html file and it displays nicely on my computer with everything properly placed and the borders/gridlines visible. How do I incorporate this into XOOPS? I tried using Freecontent, but that didn't do too well. The best I have done so far is to create a custom block and paste the html code into the block. It shows the data, but the borders and gridlines are not visible, which makes it a bit hard to read, especially since the whole sheet is wider than the space in my center block, so some of the wider fields wrap to a second line. Is there a module that will help me? is there a better way to develope the custom block? Please keep in mind that I am very new to web development and XOOPS (I have been working on this site for less than a week. Here is a link to the custom block so you can see what I have. http://tinyurl.com/2wk86

Thank-you,
Eric Benner

The short answer is to find this in your code:




and change the table tag at the end to say:



That's the easiest... but, may not have the look you want.

Another option is to adjust your tr tags with the class "even" and "odd" so that they use the colors defined in your CSS for those classes. (If you do this approach, you will probably want to ignore the previous suggestion or set the table border back to "0".)
As an example, it might look like this:


(You can look at the Top Posters block here at xoops.org or look at the source to see an idea).

You may find that the excel wizard let's you assign css classes when it does the export. I'm not sure. Anyways, I hope that gets you going.

Well, the table border command put a simple border around the whole table, but did nothing to show the grid lines within the table. I also played with different values such as which gave a thicker border. Good learning for me, but it still seems like there is something missing. If I directly link to the html file, my browser shows the gridlines see; http://tinyurl.com/342z9

would there be somwthing in the css file suppresssing the internal gridlines?

---

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00