post a topic with a excel sheet data
2 posters
Page 1 of 1
post a topic with a excel sheet data
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
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
Re: post a topic with a excel sheet data
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.
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.
Re: post a topic with a excel sheet data
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
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
Re: post a topic with a excel sheet data
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.
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.
Re: post a topic with a excel sheet data
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
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>
Similar topics
» How do I post an excel file on my forum?
» How to make number of post ,Joined date,and many other data in the post bolded and in color?
» Exporting Post Data
» Remove extra search box and post new topic inside a topic.
» LOST DATA (only topic thread)
» How to make number of post ,Joined date,and many other data in the post bolded and in color?
» Exporting Post Data
» Remove extra search box and post new topic inside a topic.
» LOST DATA (only topic thread)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum