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...

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...

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?

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!)

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.

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

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

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.

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.

BigBlueDart · 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!

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.

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.

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.

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....

BigBlueDart · 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.

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.

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.

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.

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

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

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

WooHoo!! it's working!

That Table Maker page should be a good resource now.

Upcoming Events

Event Results

Excel Copy/Paste

Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

Re: Excel Copy/Paste

USU Forums

MWC/Pac-12 Forums

Upcoming/Past Opponents

Schedules

Upcoming Events

Event Results

Basketball

National Polls/Rankings

Stats

Football

National Polls/Rankings

Stats

Newspapers

Radio

Blogs

Podcasts

Websites

Donate