Posted on 12/31/2010 4:53:52 PM PST by No_Doll_i
I need some help publishing a calendar I made in excel 2007 to a web page so I can share it with everyone. It is damn funny and try as I might I have not been able to get the thing on to a web site. Any advice? Thanks in advance!
If it is just a .xls spreadsheet you wish to convert to HTML. You can download Gnumeric (free GPL spreadsheet) and import the .xls file and “save as” and choose HTML (several options, use fragment). It does a very nice job of creating HTML tables.
THANKS! It is a multi-sheet file it that will be an issue... will check it out post haste!
You can share from there.
Windows download 1.10.11 version:
http://people.gnome.org/~mortenw/gnumeric/gnumeric-1.10.11-20101002.exe
I will try that next Thanks!!
Gnumeric is an excellent spreadsheet. It uses an XML format and saves in a XML type file. It will import Excel directly and has a very flexible .txt file importer.
One of the most unusual features is the ability to do “Find & Replace” using Regular Expressions. To my knowledge it is the only spreadsheet that will do that. I have used it for years and although some jobs are easier in Excel it has some features that are unique.
Cool, installing it now!
I use it on both my Linux and Windows machines.
Pretty intuitive except for copy and paste. You must paste to the same size block as you copy from. At times this makes it a 2 step operation. First insert lines and then paste to those lines as a block.
Other than that oddity it is pretty easy to use.
Wow. I downloaded Gnumeric but don't see anything about Regular Expressions in Find and Replace. The HELP system doesn't seem to mention it.
Does it use the UNIX or POSIX standards? Do you have a link to documentation for its use within Gnumeric? THANKS IN ADVANCE.
I guess you can tell I'm intrigued. RE would make a spreadsheet so much more powerful. I often extract data out of workbooks, run TextPad for the power of Regular Expressions, then import it back.
I think some of the newer Excel versions create HTML directly. There may be a plug-in to do that, I have not persued that because Gnumeric always worked for what I did.
http://projects.gnome.org/gnumeric/downloads.shtml
“Gnumeric relies heavily on other projects: the Perl Compatible Regular Expression engine”
Perl Compatible Regular Expression engine (here) http://pcre.org/
—
It took a little while for me to figure out how to use the “Find/Replace” RegEx radio button and syntax. But it works great.
Again, Thank you. I was able to get a few RE searches to work. I’ll read your link a learn the syntax differences. This will make life much easier.
Well I think I may have to bail on this deal for now. I guess until I go in and add the graphics files I am not going to be able to do much.
I was able to save the excel 2007 as an html file but when I load it to the web it shows up as a file in the directory but will not open. Microsoft sux!
For 5-1/2 year on my last job, I published a 3,000 page distributor catalog from an AS400 database.
Imported the text into a PC into Excel and formatted it to import into Quark with Xdata (or Xtags). There were some stages in the process (if you want to call that hack a process) where I used RegEx in Gnumeric to remove some extraneous “quotes” ‘ “ “. It did that nicely.
I used PdfTk to open the finished print document and extract the page numbers, item sequence for reprinting, and page number for the SKUs, using GREP and RegEx.
What a mess.
If I can help in any way with the RegEx let me know.
I found that RegEx is different depending on the platform you are using. There are differences in Windows and Linux. Some wild cards work in Linux and not in Windows. * is a no no in a find/replace because it means anything in Windows. Of course you can code it to mean “literal” on most things.
ping
:’)
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.