post a topic with a excel sheet data Hitskin_logo Hitskin.com

This is a Hitskin.com skin preview
Install the skinReturn to the skin page

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

    post a topic with a excel sheet data

    avatar
    lusitanos
    New Member


    Male Posts : 7
    Reputation : 0
    Language : Inglish

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

    Post by lusitanos July 30th 2007, 6:07 pm

    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
    topdown
    Forumember


    Male Posts : 36
    Reputation : 0
    Language : english

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

    Post by topdown July 31st 2007, 7:56 am

    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
    lusitanos
    New Member


    Male Posts : 7
    Reputation : 0
    Language : Inglish

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

    Post by lusitanos July 31st 2007, 10:05 am

    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
    topdown
    Forumember


    Male Posts : 36
    Reputation : 0
    Language : english

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

    Post by topdown July 31st 2007, 4:39 pm

    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
    lusitanos
    New Member


    Male Posts : 7
    Reputation : 0
    Language : Inglish

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

    Post by lusitanos July 31st 2007, 4:42 pm

    thanks that will help a lot
    avatar
    topdown
    Forumember


    Male Posts : 36
    Reputation : 0
    Language : english

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

    Post by topdown July 31st 2007, 6:04 pm

    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
    lusitanos
    New Member


    Male Posts : 7
    Reputation : 0
    Language : Inglish

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

    Post by lusitanos July 31st 2007, 6:28 pm

    Thanks this very hepfull
    avatar
    topdown
    Forumember


    Male Posts : 36
    Reputation : 0
    Language : english

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

    Post by topdown July 31st 2007, 8:07 pm

    No problem, glad to help.