Excel to Forum Software

[SOLTEC]

I need a program to be able to copy my excel spreadsheet into this and other forums. Any assistance is appreciated. Thank you.

In English Please, and again Thank You!

 

[gaz_chops]

Thx for the reply.

 

[RoryA]

That's not entirely accurate. Excel 2008 is the only version of Mac Excel that doesn't have VBA. All the others do, including 2011.

 

[gaz_chops]

So it should work?

 

[RoryA]

Which one are you referring to?

 

[gaz_chops]

I was referring to Mr.Excel.com HTML Maker, but just tried and get a runtime error!

 

[Aladin Akyurek]

I was referring to Mr.Excel.com HTML Maker, but just tried and get a runtime error!

Copied from Mac Excel 2011.
Executed cmd-v.
Activated the left most button of the 'Font' bar.
Activated the Go Advanced button of the forum.
Clicked in the posted table area.
Activated the Table Properties button on the down most bar of the forum.
Set the Table Style to Full Grid.

This is the result, comparable with the Borders-Copy-Paste method using IE.

[TABLE="class: grid, width: 130"]
<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 65"]city[/TD]
[TD="width: 65"]rating[/TD]
[/TR]
[TR]
[TD]rome[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]paris[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]istanbul[/TD]
[TD="align: right"]6[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]

 

[RoryA]

The HTML Maker won't work as it uses Windows API calls to manipulate the clipboard.

 

[gaz_chops]

Thanks Aladin, nearly but no borders! Maybe because I'm using Safari?


[TABLE="width: 290"]
<tbody>[TR]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]18-Dec-14[/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]27-Dec-14[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]beg jan 14[/TD]
[TD]10 jan 14[/TD]
[TD="align: right"]17-Jan-14[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]mid jan 14[/TD]
[TD]20 jan 14[/TD]
[TD="align: right"]30-Jan-14[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]end jan 14[/TD]
[TD]30 jan 14[/TD]
[TD="align: right"]15-Jan-14[/TD]
[TD="align: right"]-15[/TD]
[/TR]
[TR]
[TD="align: right"]15/01/14[/TD]
[TD="align: right"]15-Jan-14[/TD]
[TD="align: right"]25/01/14[/TD]
[TD="align: right"]10[/TD]
[/TR]
</tbody>[/TABLE]

I don't see "Set the Table Style to Full Grid."?

 

[Aladin Akyurek]

Thanks Aladin, nearly but no borders! Maybe because I'm using Safari?


[TABLE="width: 290"]
<tbody>[TR]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]18-Dec-14[/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]21-Dec-14[/TD]
[TD="align: right"]27-Dec-14[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]beg jan 14[/TD]
[TD]10 jan 14[/TD]
[TD="align: right"]17-Jan-14[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]mid jan 14[/TD]
[TD]20 jan 14[/TD]
[TD="align: right"]30-Jan-14[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]end jan 14[/TD]
[TD]30 jan 14[/TD]
[TD="align: right"]15-Jan-14[/TD]
[TD="align: right"]-15[/TD]
[/TR]
[TR]
[TD="align: right"]15/01/14[/TD]
[TD="align: right"]15-Jan-14[/TD]
[TD="align: right"]25/01/14[/TD]
[TD="align: right"]10[/TD]
[/TR]
</tbody>[/TABLE]

I too have used Safari. I think you missed a few steps towards the end of the recipe.

 

[RoryA]

The BBCode add-in in post #3 does work on a Mac but it needs a bit of UI work. I'll see what I can do.

Edit: now done. See the first link in my signature.