By green monkey on

i have just one Excel page that needs to be in Druapl.

Here's what I'm thinking.

create a non-book static page and paste in html data (data and table) with htlm format on.

is there any beeter tool here that I haven't noticed?

Comments

kbahey’s picture

kbahey commented

There is a Comma Separated Variable (CSV) filter module for 4.5.

You then save your Excel sheet in CSV, and paste to the node.

Also visit this page, and search inside the page for CSV for other ideas.

--
Consulting: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

green monkey’s picture

green monkey commented

you know I tried that module, got it enabled ... but couldn't find a front door to it anywhere .. so that I could use it.

I saw some others in CVS that might work.

CSV area, is this work in progress area?

thanks

ezheidtmann’s picture

ezheidtmann commented

The only trouble I have had with CSV module is positioning it correctly in the order of filters. It produces HTML tables, so it needs to go after the HTML filter. I also think it has to be before the line break filter.

There is no 4.6 release for the CSV-filter module, but the 4.5 version works fine.

green monkey’s picture

green monkey commented

I wasn't using it properly, thanks

I'll go back and try it per your notes

cel4145’s picture

cel4145 commented

If you aren't using any complex macros, with OpenOffice you can

  1. Open your Excel file in OO's spreadsheet program
  2. Select the table cells and copy.
  3. Open a new document in the OO HTML editor
  4. Paste

I'm using OpenOffice 2.0 beta. IMHO, the resulting table is pretty clean as far as HTML styling, although you will need to adjust the column widths and row heights so that Drupal will like it and add in any additional styling you want.

Note: OO has some problems with Excel macros