Excel Copy/Paste

All completed suggestions are put here.
User avatar
AGinNEIowa
Pick'em Champ - '15, '16, '17 WTHCG
Posts: 6427
Joined: January 10th, 2003, 12:00 am
Location: northeast Iowa
Has thanked: 413 times
Been thanked: 155 times

Excel Copy/Paste

Post by AGinNEIowa » November 4th, 2010, 8:56 pm

on the Scout board, I used to be able to copy data cells from Excel and paste it directly into the message body. Here it doesn't work.

any suggestions? Pick'em Standings will be a major pain, if I have to go through the table process for a table with 30 people and up to 15 weeks...


2020 PICK'EM GOOGLE Docs -
BOWLS (pick entry)

WEEK 15 (results)

User avatar
treesap32
Moderator
Posts: 15110
Joined: July 28th, 2005, 1:00 am
Location: Washington D.C.
Has thanked: 308 times
Been thanked: 701 times
Contact:

Re: Excel Copy/Paste

Post by treesap32 » November 4th, 2010, 8:58 pm

Screenshot of the excel sheet as .jpg then uploaded? That's what I've done on other PHPBB boards in the past...



User avatar
ProvoAggie
Site Admin
Posts: 13254
Joined: June 14th, 2010, 1:00 am
Location: Provo, Utah
Has thanked: 836 times
Been thanked: 1105 times
Contact:

Re: Excel Copy/Paste

Post by ProvoAggie » November 4th, 2010, 9:15 pm

There is an add-on for phpBB that will allow you to attach XLS files to your post and have them appear as tables in your post. I will work on installing it and see how well it works. Would that make it easier?



User avatar
AGinNEIowa
Pick'em Champ - '15, '16, '17 WTHCG
Posts: 6427
Joined: January 10th, 2003, 12:00 am
Location: northeast Iowa
Has thanked: 413 times
Been thanked: 155 times

Re: Excel Copy/Paste

Post by AGinNEIowa » November 4th, 2010, 9:52 pm

ProvoAggie wrote:There is an add-on for phpBB that will allow you to attach XLS files to your post and have them appear as tables in your post. I will work on installing it and see how well it works. Would that make it easier?
YES!

also notice no "Quick Reply" in this forum.

Thanks ProAg (can't stand to even type the city name!)


2020 PICK'EM GOOGLE Docs -
BOWLS (pick entry)

WEEK 15 (results)

User avatar
ProvoAggie
Site Admin
Posts: 13254
Joined: June 14th, 2010, 1:00 am
Location: Provo, Utah
Has thanked: 836 times
Been thanked: 1105 times
Contact:

Re: Excel Copy/Paste

Post by ProvoAggie » November 4th, 2010, 10:04 pm

AGinNEIowa wrote:Thanks ProAg (can't stand to even type the city name!)
At least you don't live there...also, Quick Reply is here now.



User avatar
BigBlueDart
Pick'em Champ - '17 FB Predict the Score
Posts: 8132
Joined: November 3rd, 2010, 7:57 am
Location: Syracuse, UT
Has thanked: 82 times
Been thanked: 315 times

Re: Excel Copy/Paste

Post by BigBlueDart » November 4th, 2010, 11:57 pm

This would be great. BBCode tables are kind of tough if they get very big.



User avatar
ProvoAggie
Site Admin
Posts: 13254
Joined: June 14th, 2010, 1:00 am
Location: Provo, Utah
Has thanked: 836 times
Been thanked: 1105 times
Contact:

Re: Excel Copy/Paste

Post by ProvoAggie » November 5th, 2010, 7:35 am

I guess you didn't see the other post. You can actually do HTML tables now and they don't have to be contained on 1 row. The only HTML tags allowed on the site are table, th, tr, and td.



User avatar
AGinNEIowa
Pick'em Champ - '15, '16, '17 WTHCG
Posts: 6427
Joined: January 10th, 2003, 12:00 am
Location: northeast Iowa
Has thanked: 413 times
Been thanked: 155 times

Re: Excel Copy/Paste

Post by AGinNEIowa » November 5th, 2010, 7:56 am

I don't know any html, and was trying to use the example you posted in the other thread, it took me 10 min to figure out 3 lines. With 30 weekly participants in Pick'em, I just don't have that much time to enter a table for standings.


2020 PICK'EM GOOGLE Docs -
BOWLS (pick entry)

WEEK 15 (results)

User avatar
BigBlueDart
Pick'em Champ - '17 FB Predict the Score
Posts: 8132
Joined: November 3rd, 2010, 7:57 am
Location: Syracuse, UT
Has thanked: 82 times
Been thanked: 315 times

Re: Excel Copy/Paste

Post by BigBlueDart » November 5th, 2010, 9:38 am

BBCode and HTML are both a bit tedious to do large tables by hand. I might be able to write a macro, but if cutting and pasting excel spreadsheets was an option it could help.

I'm sure we'll all be fine, regardless. Don't let yourself get too bogged down by all the suggestions. The site is absolutely fantastic!



User avatar
ProvoAggie
Site Admin
Posts: 13254
Joined: June 14th, 2010, 1:00 am
Location: Provo, Utah
Has thanked: 836 times
Been thanked: 1105 times
Contact:

Re: Excel Copy/Paste

Post by ProvoAggie » November 5th, 2010, 11:08 am

I have installed the module to show Excel files inline and it appears to work pretty well. There are a few things to note. It does remove all formatting from the document so it shows a plain table. The files have to be .xls files...if you made them with Excel 2007-2010, save them as an Excel 97-2003 file. Also, If it's a big document, it will have a scrollbar. This should make posting tables quite a bit easier...especially for those of you that are coming from Excel files to begin with.
Attachments
Test.xls
(25 KiB) Downloaded 141 times



User avatar
AGinNEIowa
Pick'em Champ - '15, '16, '17 WTHCG
Posts: 6427
Joined: January 10th, 2003, 12:00 am
Location: northeast Iowa
Has thanked: 413 times
Been thanked: 155 times

Re: Excel Copy/Paste

Post by AGinNEIowa » November 5th, 2010, 1:23 pm

so it's a file attachment, not copy/paste? I guess I'll have to change my process.


2020 PICK'EM GOOGLE Docs -
BOWLS (pick entry)

WEEK 15 (results)

User avatar
ProvoAggie
Site Admin
Posts: 13254
Joined: June 14th, 2010, 1:00 am
Location: Provo, Utah
Has thanked: 836 times
Been thanked: 1105 times
Contact:

Re: Excel Copy/Paste

Post by ProvoAggie » November 5th, 2010, 1:29 pm

It is just an attachment. It will be a bit different but it shouldn't be too difficult. The biggest difference between scout and here is that they have a WYSIWYG editor that converts things to HTML. By allowing HTML, you open the door for security problems and so phpBB doesn't support it.



User avatar
treesap32
Moderator
Posts: 15110
Joined: July 28th, 2005, 1:00 am
Location: Washington D.C.
Has thanked: 308 times
Been thanked: 701 times
Contact:

Re: Excel Copy/Paste

Post by treesap32 » November 15th, 2010, 9:43 am

I found a very useful site for those of us who like to post formatted date (tables). This site will let you paste in comma or tab separated input and will automatically put it into HTML table format for you.

http://www.bagism.com/tablemaker/

Now if we could just figure out how to get rid of that blasted spacing before the tables....



User avatar
BigBlueDart
Pick'em Champ - '17 FB Predict the Score
Posts: 8132
Joined: November 3rd, 2010, 7:57 am
Location: Syracuse, UT
Has thanked: 82 times
Been thanked: 315 times

Re: Excel Copy/Paste

Post by BigBlueDart » November 15th, 2010, 10:10 am

treesap32 wrote:I found a very useful site for those of us who like to post formatted date (tables). This site will let you paste in comma or tab separated input and will automatically put it into HTML table format for you.

http://www.bagism.com/tablemaker/

Now if we could just figure out how to get rid of that blasted spacing before the tables....
You need to put all the code on one line. Maybe go ahead and us the automatic table generator and then go back and manually remove all the carriage returns and extra white space.



User avatar
ProvoAggie
Site Admin
Posts: 13254
Joined: June 14th, 2010, 1:00 am
Location: Provo, Utah
Has thanked: 836 times
Been thanked: 1105 times
Contact:

Re: Excel Copy/Paste

Post by ProvoAggie » November 15th, 2010, 10:29 am

It doesn't have to be all on one line but right now you can't have any space at the beginning of a row. What is happening is phpBB is putting a <br /> in after each line...and because you can't have a break in between 2 columns they all appear above the table. I have some code in to remove it but for some reason it is failing when there are spaces at the beginning of the new rows. I'm trying to figure out why right now and hopefully it will be fixed soon.



User avatar
treesap32
Moderator
Posts: 15110
Joined: July 28th, 2005, 1:00 am
Location: Washington D.C.
Has thanked: 308 times
Been thanked: 701 times
Contact:

Re: Excel Copy/Paste

Post by treesap32 » November 15th, 2010, 10:38 am

ProvoAggie wrote:It doesn't have to be all on one line but right now you can't have any space at the beginning of a row. What is happening is phpBB is putting a <br /> in after each line...and because you can't have a break in between 2 columns they all appear above the table. I have some code in to remove it but for some reason it is failing when there are spaces at the beginning of the new rows. I'm trying to figure out why right now and hopefully it will be fixed soon.
I see. Thanks for fixing it.

I just went in the sandbox and tested it and now I see what you mean.

The following code works fine by the way for BBD to see: (I added a "." so it wouldn't process the table).

Code: Select all

<.TABLE BORDER=1>
<.TR>
<.TD>Date <./TD>
<.TD>Season <./TD>
<.TD>Opponent <./TD>
<.TD>Home/Away  <./TD>
<.TD>Win/Loss <./TD>
<.TD>Score <./TD>
<.TD>Game Type <./TD>
<.TD>Attendance<./TD>
<./TR>
<.TR>
<.TD>2009-12-16<./TD>
<.TD>2009-10<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>A<./TD>
<.TD>W<./TD>
<.TD>68-51<./TD>
<.TD>Non-Conference<./TD>
<.TD>4481<./TD>
<./TR>
<.TR>
<.TD>2009-02-18<./TD>
<.TD>2008-09<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>H<./TD>
<.TD>W<./TD>
<.TD>78-57<./TD>
<.TD>Non-Conference<./TD>
<.TD>8189<./TD>
<./TR>
<.TR>
<.TD>2007-12-08<./TD>
<.TD>2007-08<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>A<./TD>
<.TD>W<./TD>
<.TD>88-66<./TD>
<.TD>Non-Conference<./TD>
<.TD>1739<./TD>
<./TR>
<.TR>
<.TD>2006-12-30<./TD>
<.TD>2006-07<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>H<./TD>
<.TD>W<./TD>
<.TD>65-49<./TD>
<.TD>Non-Conference<./TD>
<.TD>8049<./TD>
<./TR>
<.TR>
<.TD>1977-01-04<./TD>
<.TD>1976-77<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>H<./TD>
<.TD>W<./TD>
<.TD>110-89<./TD>
<.TD>Non-Conference<./TD>
<.TD>6522<./TD>
<./TR>
<./TABLE>
This code doesn't work because of the spaces before each <TD>:

Code: Select all

<.TABLE BORDER=1>
<.TR>
  <.TD>Date <./TD>
  <.TD>Season <./TD>
  <.TD>Opponent <./TD>
  <.TD>Home/Away  <./TD>
  <.TD>Win/Loss <./TD>
  <.TD>Score <./TD>
  <.TD>Game Type <./TD>
  <.TD>Attendance<./TD>
<./TR>
<.TR>
  <.TD>2009-12-16<./TD>
  <.TD>2009-10<./TD>
  <.TD>Cal State Bakersfield<./TD>
  <.TD>A<./TD>
  <.TD>W<./TD>
  <.TD>68-51<./TD>
  <.TD>Non-Conference<./TD>
  <.TD>4481<./TD>
<./TR>
<.TR>
  <.TD>2009-02-18<./TD>
  <.TD>2008-09<./TD>
  <.TD>Cal State Bakersfield<./TD>
  <.TD>H<./TD>
  <.TD>W<./TD>
  <.TD>78-57<./TD>
  <.TD>Non-Conference<./TD>
  <.TD>8189<./TD>
<./TR>
<.TR>
  <.TD>2007-12-08<./TD>
  <.TD>2007-08<./TD>
  <.TD>Cal State Bakersfield<./TD>
  <.TD>A<./TD>
  <.TD>W<./TD>
  <.TD>88-66<./TD>
  <.TD>Non-Conference<./TD>
  <.TD>1739<./TD>
<./TR>
<.TR>
  <.TD>2006-12-30<./TD>
  <.TD>2006-07<./TD>
  <.TD>Cal State Bakersfield<./TD>
  <.TD>H<./TD>
  <.TD>W<./TD>
  <.TD>65-49<./TD>
  <.TD>Non-Conference<./TD>
  <.TD>8049<./TD>
<./TR>
<.TR>
  <.TD>1977-01-04<./TD>
  <.TD>1976-77<./TD>
  <.TD>Cal State Bakersfield<./TD>
  <.TD>H<./TD>
  <.TD>W<./TD>
  <.TD>110-89<./TD>
  <.TD>Non-Conference<./TD>
  <.TD>6522<./TD>
<./TR>
<./TABLE>
A quick Find & Replace in notepad did the job.



User avatar
ProvoAggie
Site Admin
Posts: 13254
Joined: June 14th, 2010, 1:00 am
Location: Provo, Utah
Has thanked: 836 times
Been thanked: 1105 times
Contact:

Re: Excel Copy/Paste

Post by ProvoAggie » November 15th, 2010, 10:54 am

It should be fixed now. You are able to have up to 5 spaces on the beginning of a row. If you have more than that then it may or may not have spaces.



User avatar
BigBlueDart
Pick'em Champ - '17 FB Predict the Score
Posts: 8132
Joined: November 3rd, 2010, 7:57 am
Location: Syracuse, UT
Has thanked: 82 times
Been thanked: 315 times

Re: Excel Copy/Paste

Post by BigBlueDart » November 15th, 2010, 11:07 am

Okay, I see what my issue was before. Thanks!



User avatar
treesap32
Moderator
Posts: 15110
Joined: July 28th, 2005, 1:00 am
Location: Washington D.C.
Has thanked: 308 times
Been thanked: 701 times
Contact:

Re: Excel Copy/Paste

Post by treesap32 » November 15th, 2010, 11:08 am

WooHoo!! it's working!

That Table Maker page should be a good resource now. :cheers:



Post Reply Previous topicNext topic