The forum of the forums
Would you like to react to this message? Create an account in a few clicks or log in to continue.

post a topic with a excel sheet data

2 posters

Go down

post a topic with a excel sheet data Empty post a topic with a excel sheet data

Post by lusitanos Mon 30 Jul 2007 - 18:07

Hello
I have a forum, and i´m trying to post a topic with data from an excel sheet, but i can´t make it when i past it on the "message body" it loses the formats and colors.
i just need that the data from the excel sheet doesn´t lose the format,or colors and i have no formulas in the sheet of the excel.
Example
2 rows for 5 columns like the picture
https://servimg.com/view/11441044/1

data
subject
in
out
total

04-01-2007
aaa
500,00 €

500,00 €

can some one help me
avatar
lusitanos
New Member

Male Posts : 7
Reputation : 0
Language : Inglish

http://lusitanos.forumotion.com/

Back to top Go down

post a topic with a excel sheet data Empty Re: post a topic with a excel sheet data

Post by topdown Tue 31 Jul 2007 - 7:56

You will need to do it manually as far as I can tell with some simple html coding

First
Go to Admin Panel / User Admin & Groups /
User and Forum Settings

close to the bottom it says
User and Forum Settings
and asks ALLOW HTML set to yes to embed things in posts like games

Then you can use HTML tables to make it look like an excel sheet.

If html coding is a problem for you let me know.
Tables in HTML are a little advanced.
If I knew what you needed for a table I could code you one and set up some instructions.
avatar
topdown
Forumember

Male Posts : 36
Reputation : 0
Language : english

http://topdown.forumotion.com/

Back to top Go down

post a topic with a excel sheet data Empty Re: post a topic with a excel sheet data

Post by lusitanos Tue 31 Jul 2007 - 10:05

hello,
I have the "ALLOW HTML" active as yes.
But i don´t know who to do html coding but i´m a lern fast.
Let me see if i can explain it to you i need a table whith, like the picture and that is a part of the the table, the function of the table is to show movements of an a bank account.

https://servimg.com/view/11441044/2

the first row is always the same, the rest of the rows they change.

i hope that you can help me whith this problem
I m sorry for my english
avatar
lusitanos
New Member

Male Posts : 7
Reputation : 0
Language : Inglish

http://lusitanos.forumotion.com/

Back to top Go down

post a topic with a excel sheet data Empty Re: post a topic with a excel sheet data

Post by topdown Tue 31 Jul 2007 - 16:39

I could make a HTML table for that but you would need to update the rows that change manually when needed.

For it to happen by itself would take some major scripting, which I don't think is even possible on these accounts.

But I will make the table and get back to you.
avatar
topdown
Forumember

Male Posts : 36
Reputation : 0
Language : english

http://topdown.forumotion.com/

Back to top Go down

post a topic with a excel sheet data Empty Re: post a topic with a excel sheet data

Post by lusitanos Tue 31 Jul 2007 - 16:42

thanks that will help a lot
avatar
lusitanos
New Member

Male Posts : 7
Reputation : 0
Language : Inglish

http://lusitanos.forumotion.com/

Back to top Go down

post a topic with a excel sheet data Empty Re: post a topic with a excel sheet data

Post by topdown Tue 31 Jul 2007 - 18:04

Make sure you have the HTML enables in your forum
This code should work for you, I didn't use any special characters for what you had in the cells so you may want to edit them.

You can easily edit and make changes in Notepad or your favorite HTML editor.
I use NotePad++ is very efficient and all I use, Google it, it's free.
Here is a preview where I tested it
http://topdown.forumotion.com/Basket-f2/-p6.htm#6
Code:
<table border="2" bgcolor="#CCFFFF" class="forumline"> <tr bgcolor="purple"> <td><font color="white"><b>Data</b></font></td> <td><font color="white"><b>Descricao</b></font></td> <td><font color="white"><b>Credito</b></font></td> <td><font color="white"><b>Debito</b></font></td> <td><font color="white"><b>Saldo</b></font></td> </tr>
<tr> <td bgcolor="blue"><b>04-01-2007</b></td> <td>Abertura</td>    <td>500,00</td>  <td></td>      <td>500,00</td></tr>
 <tr> <td bgcolor="blue"><b>05-01-2007</b></td> <td>Cheques</td>    <td></td>        <td>-5,27</td> <td>494,73</td></tr>
 <tr> <td bgcolor="blue"><b>09-01-2007</b></td> <td>Manchinha</td>  <td>82,00</td>    <td></td>      <td>576,73</td></tr>
 <tr> <td bgcolor="blue"><b>16-01-2007</b></td> <td>Domingos</td>    <td>72,00</td>    <td></td>      <td>648,73</td></tr>
 <tr> <td bgcolor="blue"><b>12-02-2007</b></td> <td>Treino 4/02/2007</td> <td>296,40</td> <td></td>  <td>945,13</td></tr>
 <tr> <td bgcolor="blue"><b>12-02-2007</b></td> <td>Novo socio</td>  <td>86,00</td>    <td></td>      <td>1.032,13</td></tr>
 <tr> <td bgcolor="blue"><b>12-02-2007</b></td> <td>Dinherio devido ao clube</td><td>2,00</td><td></td><td>1.033,13</td></tr>
 <tr> <td bgcolor="blue"><b>13-02-2007</b></td> <td>1 cheque</td>  <td></td>    <td>-275.00</td>      <td>758,13</td></tr>
 <tr> <td bgcolor="blue"><b>28-02-2007</b></td> <td>2 cheque</td>  <td></td>    <td>-275.00</td>      <td>483,13</td></tr>
 </table>
avatar
topdown
Forumember

Male Posts : 36
Reputation : 0
Language : english

http://topdown.forumotion.com/

Back to top Go down

post a topic with a excel sheet data Empty Re: post a topic with a excel sheet data

Post by lusitanos Tue 31 Jul 2007 - 18:28

Thanks this very hepfull
avatar
lusitanos
New Member

Male Posts : 7
Reputation : 0
Language : Inglish

http://lusitanos.forumotion.com/

Back to top Go down

post a topic with a excel sheet data Empty Re: post a topic with a excel sheet data

Post by topdown Tue 31 Jul 2007 - 20:07

No problem, glad to help.
avatar
topdown
Forumember

Male Posts : 36
Reputation : 0
Language : english

http://topdown.forumotion.com/

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum