Main Area and Open Discussion > General Software Discussion

Converting Spreadsheet to Table in forum

(1/9) > >>

tomos:
I'm trying to convert a (LARGE) spreadsheet file to a Table that will post here

e.g. from the Mini-Review Tamplate
App NameName of app reviewedApp URLLink to the app's homepageApp Version ReviewedVersion being reviewed
which actually is

--- ---[table]
[tr][td][b]App Name[/b][/td][td]Name of app reviewed[/td][/tr]
[tr][td][b]App URL[/b][/td][td]Link to the app's homepage[/td][/tr]
[tr][td][b]App Version Reviewed[/b][/td][td]Version being reviewed[/td][/tr]
[/table]
I was wondering, using some sort of find & replace &
some way of adding prefix/suffix to lines
could I convert the seperators in a .CSV file to the appropriate table "td" thingys  :)

I'm sorry the only way I can show this is as code -
otherwise it forms crazy tables & cant be read properly.
Makes it hard to read but you could cut & paste it elsewhere


--- ---I thought I was being very smart -
I saved file as .csv file and tried to use [tr][td] instead of a comma as a separator.
But
only the first character "[" came through

But got me thinking
would there be a way of
prefixing each line with "[tr][td]"
suffixing each line with "[/td][/tr]"

and then using some sort of find & replace function to replace the separator with "[/td][td]"
(I could do that in Freehand but I'm sure some text editors would have it)

I would then at the end of each line have "[/td][td][/td][/tr]"
where i think the first two "[/td][td]" would have to be removed
but
I could live with deleting that "by hand" if I could get the rest automated to a certain extent ...
I can live without this but found it an interesting challenge - if you do too, please help if you can  :D  :up:

PS I did try pasting html table in post but it looses format, see dc thread here

[EDIT: solution I used is here, post#27/30  thanks, crono!

app103:
Converting spreadsheets to something you can post here can be hell.  :(

First you would have to convert it to html, somehow. That is best done manually or in an html editor, as it is the only way it will look good. Using the 'export as html' option can have some bad results.

Make sure it is stripped of all extra code that is unnecessary, such as font sizes & colors, table & cell width info, etc.

Then you would have to do a find & replace of all the <'s with ['s and then all the >'s with ]'s

tomos:
Then you would have to do a find & replace of all the <'s with ['s and then all the >'s with ]'s
-app103 (May 12, 2007, 03:55 AM)
--- End quote ---
thats the easy bit methinks  :)

First you would have to convert it to html, somehow. That is best done manually or in an html editor, as it is the only way it will look good. Using the 'export as html' option can have some bad results.

Make sure it is stripped of all extra code that is unnecessary, such as font sizes & colors, table & cell width info, etc.-app103 (May 12, 2007, 03:55 AM)
--- End quote ---
I think I'm out of my depth there already app  :(

Well I just had a look at the html version as exported from OOo, jeez, what a load of code  :)

Tried stripping out some stuff (find, replace)
but definitely starting to think this might be more work than it's worth

Nope that's definitely beyond my capabilities ...


When you say "First you would have to convert it to html ... in an html editor"
Would i have to go back to school to figure that one out ?  :tellme:  :D
Would it be a very time consuming process?

app103:
Well I just had a look at the html version as exported from OOo, jeez, what a load of code  :)

Tried stripping out some stuff (find, replace)
but definitely starting to think this might be more work than it's worth

Nope that's definitely beyond my capabilities ...
-tomos (May 12, 2007, 06:31 AM)
--- End quote ---

You just discovered why I said not to do that.  ;D

When you say "First you would have to convert it to html ... in an html editor"
Would i have to go back to school to figure that one out ?  :tellme:  :D
Would it be a very time consuming process?
-tomos (May 12, 2007, 06:31 AM)
--- End quote ---

There are WYSIWYG html editors where you can create a table as easily as painting in MS Paint.

Recreate the table in one of those and copy & paste the data from the spreadsheet into the boxes.

Then you go through and make sure you remove all that extra stuff from the code, like I mentioned before.

Like I said, it can be hell.  :-[

I think what we need around here is a WYSIWYG forum post editor for creating the bbcode. Then you wouldn't have to create a spreadsheet and go through all this. You could create it in the editor instead.

tomos:
thanks, app

think I'll have to reconsider ...

It's the List of Disc Cataloguers that Crush prepared that I was hoping to fit in a post on thread of same name.
The list now has 213 entries, with, I think, four columns ...

You can see why I'm looking for some kind of automated solution ...

Do you think the idea of replacing separators in a .csv file is a non runner
(see post one, esp the second code box, for anyone who hasn't a clue what I'm on about :) )

Navigation

[0] Message Index

[#] Next page