Hi there!
I am using this process.
When CSv file is generated, it starts from row number 2. Can anyone please guide me how to set row 1?
Discussion posts and replies are publicly visible
Please suggest.I am using this html.
<HTML> <BODY> <section><table name="department" width="100%"> <tr> <td><label> <b> Name </b> </label> </td> <td><label> <b> date </b> </label> </td> <td><label> <b> Side </b> </label></td> <td><label> <b> Quantity </b> </label></td> <td><label> <b> Address </b> </label> </td> <td><label> <b> Account </b> </label> </td> </tr> ###deprt_body### </table></section>
</BODY> </HTML>
manjit.1486 the fields Name, date, Side etc are they headers if yes. Use the <th> html tag.
I think it will solve your issue
manjit.1486
I just tried with the below HTML and it rendered perfect for me.
<html> <head> </head> <body> <h2>HTML Table</h2> <table> <tr> <th>Company</th> <th>Contact</th> <th>Country</th> </tr> <tr> <td>Alfreds Futterkiste</td> <td>Maria Anders</td> <td>Germany</td> </tr> <tr> <td>Centro comercial Moctezuma</td> <td>Francisco Chang</td> <td>Mexico</td> </tr> <tr> <td>Ernst Handel</td> <td>Roland Mendel</td> <td>Austria</td> </tr> <tr> <td>Island Trading</td> <td>Helen Bennett</td> <td>UK</td> </tr> <tr> <td>Laughing Bacchus Winecellars</td> <td>Yoshi Tannamuri</td> <td>Canada</td> </tr> <tr> <td>Magazzini Alimentari Riuniti</td> <td>Giovanni Rovelli</td> <td>Italy</td> </tr> </table> </body> </html>
Try replacing all the <td> with <th> in your HTML template and should work. This is also what JayaPrakash suggested
Try using this from next time for better readability
Thanks for your suggestion. It worked. Great, thanks
Sure, I will keep this in my mind.
Yes, it worked for me as well. Thanks for your time.
Why do you create a HTML just to convert it to a CSV?
Because I need csv file on demand - in this case I need to fetch data from process variables not from database table. That's why I am using convert HTMl to CSV smart service.
OK, but using the "Text Document from Template" smart service, you can easily create that CSV directly.