Free Republic
Browse · Search
General/Chat
Topics · Post Article

Skip to comments.

Vanity - Help, I want to share a calendar with everyone on FR
my brain | 12/31/10 | no_doll_i

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!


TOPICS: Computers/Internet; Miscellaneous; Weird Stuff
KEYWORDS: calendar
I think it may be a version issue with frontpage and excel.
1 posted on 12/31/2010 4:53:55 PM PST by No_Doll_i
[ Post Reply | Private Reply | View Replies]

To: No_Doll_i

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.


2 posted on 12/31/2010 4:59:10 PM PST by Texas Fossil (Government, even in its best state is but a necessary evil; in its worst state an intolerable one.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Texas Fossil

THANKS! It is a multi-sheet file it that will be an issue... will check it out post haste!


3 posted on 12/31/2010 5:01:34 PM PST by No_Doll_i
[ Post Reply | Private Reply | To 2 | View Replies]

To: No_Doll_i
Can you convert it to a Google document?

You can share from there.

4 posted on 12/31/2010 5:03:58 PM PST by E. Pluribus Unum (DEFCON I ALERT: The federal cancer has metastasized. All personnel report to their battle stations.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: No_Doll_i

Windows download 1.10.11 version:

http://people.gnome.org/~mortenw/gnumeric/gnumeric-1.10.11-20101002.exe


5 posted on 12/31/2010 5:06:07 PM PST by Texas Fossil (Government, even in its best state is but a necessary evil; in its worst state an intolerable one.)
[ Post Reply | Private Reply | To 3 | View Replies]

To: E. Pluribus Unum

I will try that next Thanks!!


6 posted on 12/31/2010 5:09:31 PM PST by No_Doll_i
[ Post Reply | Private Reply | To 4 | View Replies]

To: No_Doll_i

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.


7 posted on 12/31/2010 5:10:25 PM PST by Texas Fossil (Government, even in its best state is but a necessary evil; in its worst state an intolerable one.)
[ Post Reply | Private Reply | To 3 | View Replies]

To: Texas Fossil

Cool, installing it now!


8 posted on 12/31/2010 5:11:54 PM PST by No_Doll_i
[ Post Reply | Private Reply | To 7 | View Replies]

To: No_Doll_i

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.


9 posted on 12/31/2010 5:17:58 PM PST by Texas Fossil (Government, even in its best state is but a necessary evil; in its worst state an intolerable one.)
[ Post Reply | Private Reply | To 8 | View Replies]

To: Texas Fossil
Yeah seems the only problem is it is not able to read the graphics files I laid into the thing. I will explore further but am trying to just upload it to google docs for the moment. This is most aggravating LoL
10 posted on 12/31/2010 5:34:00 PM PST by No_Doll_i
[ Post Reply | Private Reply | To 9 | View Replies]

To: Texas Fossil
One of the most unusual features is the ability to do “Find & Replace” using Regular Expressions.

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.

11 posted on 12/31/2010 5:35:11 PM PST by gitmo ( The democRats drew first blood. It's our turn now.)
[ Post Reply | Private Reply | To 7 | View Replies]

To: No_Doll_i

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.


12 posted on 12/31/2010 5:36:28 PM PST by Texas Fossil (Government, even in its best state is but a necessary evil; in its worst state an intolerable one.)
[ Post Reply | Private Reply | To 10 | View Replies]

To: No_Doll_i

Test This!

https://docs.google.com/leaf?id=0B3HQrems_hXLZjc4OGJiMWYtNTI4NS00NzMwLWI1NjEtNTU1YWQzYTljOTU4&hl=en&authkey=COallJoC


13 posted on 12/31/2010 5:40:12 PM PST by No_Doll_i
[ Post Reply | Private Reply | To 10 | View Replies]

To: gitmo

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.


14 posted on 12/31/2010 5:43:51 PM PST by Texas Fossil (Government, even in its best state is but a necessary evil; in its worst state an intolerable one.)
[ Post Reply | Private Reply | To 11 | View Replies]

To: Texas Fossil

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.


15 posted on 12/31/2010 5:45:37 PM PST by gitmo ( The democRats drew first blood. It's our turn now.)
[ Post Reply | Private Reply | To 14 | View Replies]

To: Texas Fossil

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!


16 posted on 12/31/2010 5:46:50 PM PST by No_Doll_i
[ Post Reply | Private Reply | To 12 | View Replies]

To: gitmo

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.


17 posted on 12/31/2010 5:50:22 PM PST by Texas Fossil (Government, even in its best state is but a necessary evil; in its worst state an intolerable one.)
[ Post Reply | Private Reply | To 11 | View Replies]

To: gitmo

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.


18 posted on 12/31/2010 5:55:34 PM PST by Texas Fossil (Government, even in its best state is but a necessary evil; in its worst state an intolerable one.)
[ Post Reply | Private Reply | To 15 | View Replies]

To: ShadowAce

ping


19 posted on 01/01/2011 4:30:37 AM PST by raybbr (Someone who invades another country is NOT an immigrant - illegal or otherwise.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Ernest_at_the_Beach; Seadog Bytes; JoeProBono; Swordmaker

:’)


20 posted on 01/01/2011 7:41:48 AM PST by SunkenCiv (The 2nd Amendment follows right behind the 1st because some people are hard of hearing.)
[ Post Reply | Private Reply | To 16 | View Replies]

To: SunkenCiv

HAPPY NEW YEAR


21 posted on 01/01/2011 7:54:31 AM PST by JoeProBono (A closed mouth gathers no feet - Visualize)
[ Post Reply | Private Reply | To 20 | View Replies]

To: No_Doll_i; rdb3; Calvinist_Dark_Lord; GodGunsandGuts; CyberCowboy777; Salo; Bobsat; JosephW; ...

22 posted on 01/01/2011 7:59:41 AM PST by ShadowAce (Linux -- The Ultimate Windows Service Pack)
[ Post Reply | Private Reply | To 1 | View Replies]

To: No_Doll_i

IF you have it to html then copy the source code, enter it in the post screen and preview. See what you get then.


23 posted on 01/01/2011 8:02:22 AM PST by deport
[ Post Reply | Private Reply | To 16 | View Replies]

To: ShadowAce; deport

Thanks much!


24 posted on 01/01/2011 9:10:12 AM PST by No_Doll_i
[ Post Reply | Private Reply | To 22 | View Replies]

To: deport

Hmmmm, that didn’t work out too well. I think what I will have to do is save each sheet as a file, convert to html or pdf and transfer each to a web page like that. Seem reasonable. Honestly I have built websites and am not completely clueless but this makes no sense to me.


25 posted on 01/01/2011 9:18:49 AM PST by No_Doll_i
[ Post Reply | Private Reply | To 23 | View Replies]

To: No_Doll_i

If you post a link to it as a file, I’ll convert it to an .ics file type for everyone. An .ics file is a data file that can used for calendars, messaging, tasks, etc., and is importable to a wide variety of Calendars across different platforms.

Such as...

All Mozilla email clients (e.g. Thunderbird/Lightning)
Google Calendar
Apple iCal
Online Group Calendar
IBM Lotus Notes
Microsoft Outlook


26 posted on 01/01/2011 10:54:07 AM PST by papasmurf (sudo apt-get install Lee Atwater)
[ Post Reply | Private Reply | To 1 | View Replies]

To: JoeProBono

Thanks JPB!


27 posted on 01/01/2011 11:11:50 AM PST by SunkenCiv (The 2nd Amendment follows right behind the 1st because some people are hard of hearing.)
[ Post Reply | Private Reply | To 21 | View Replies]

To: papasmurf

Thanks papasmurf! I uploaded it again. It is not exactly right and it can’t be downloaded for whatever reason but if you want to check it out please do

http://nodoll.ipower.com/calendar%20V.X.htm

I need to change something to make it downloadable and I may be able to figure that out here in a few


28 posted on 01/01/2011 11:44:39 AM PST by No_Doll_i
[ Post Reply | Private Reply | To 26 | View Replies]

To: No_Doll_i
Yeah, I dl'd it from the link. But, .ics doesn't support images/graphics, only text.

That calendar of yours is graphic intensive! 82MB lol

I don't know what your email client is, or if you have Calendaring support, but see if it supports iCal, iCalendar, or .ics files. If it does, you might want to download this Holiday Calendar file and import it, then modify it to your liking...minus the graphics. lol
29 posted on 01/01/2011 12:34:02 PM PST by papasmurf (sudo apt-get install Lee Atwater)
[ Post Reply | Private Reply | To 28 | View Replies]

To: papasmurf

Thanks, but damn I spent a hell of a lot of time pasting all those graphic together so I will just have to live with it as is I guess. LoL Could you at least see the thing from the link?


30 posted on 01/01/2011 12:39:55 PM PST by No_Doll_i
[ Post Reply | Private Reply | To 29 | View Replies]

To: No_Doll_i

Downloaded from you link just fine. What a Labor Intensive piece of work!


31 posted on 01/01/2011 1:17:40 PM PST by JoeProBono (A closed mouth gathers no feet - Visualize)
[ Post Reply | Private Reply | To 30 | View Replies]

To: No_Doll_i; JoeProBono

Yeah, what he (JPB) said. haha

Good luck.


32 posted on 01/01/2011 3:10:25 PM PST by papasmurf (sudo apt-get install Lee Atwater)
[ Post Reply | Private Reply | To 30 | View Replies]

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.

Free Republic
Browse · Search
General/Chat
Topics · Post Article

FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson