Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Converting HTML data into a spreadsheet

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Converting HTML data into a spreadsheet
# 1  
Old 04-21-2008
Converting HTML data into a spreadsheet
Hi,

I have a perl script that prints some data in the form of a table (HTML table) Now, I want to be able to convert this data into a report on an Excel sheet. How can I do this?

Regards,
Garric
# 2  
Old 04-21-2008
Modding the script is probably less frustrating than parsing HTML tables.

Tab-delimited or comma-delimited should be fine for any spreadsheet.

(I wouldn't be surprised if Excel and/or OOo had limited support for directly importing HTML tables these days, either.)
# 3  
Old 04-22-2008
Thanks, a comma seperated list wont be a problem. Any idea how I can add the 'file creation box' (the one that pops up when we try creating a new file on wondows) on the html web page? Can you help?
# 4  
Old 04-22-2008
if you are planning to create a fancy excel sheet, then Spreadsheet::WriteExcel will help you
# 5  
Old 04-22-2008
Try this awk
awk 'BEGIN{
FS="|"
print "<HTML><BODY><TABLE border=1>"
}
{

printf "<TR>"
if(i=1)
printf "<TD ALIGN=\"LEFT\" width=\"100\" height=\"25\"><font size=\"2\" face=\"Verdana\"><b>%s</font></b></TD>", $i
if(i=2)
printf "<TD ALIGN=\"LEFT\" width=\"300\" height=\"25\"><font size=\"2\" face=\"Verdana\">%s</font></TD>", $i
if(i=3)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\"><font size=\"2\" face=\"Verdana\">%s</font></TD>", $i
if(i=4)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\"><font size=\"2\" face=\"Verdana\">%s</font></TD>", $i
if(i=5)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\"><font size=\"2\" face=\"Verdana\">%s</font></TD>", $i
if(i=6)
printf "<TD ALIGN=\"LEFT\" width=\"80\" height=\"25\"><font size=\"2\" face=\"Verdana\">%s</font></TD>", $i
}
END{
print "</TABLE></BODY></HTML>"
}
' file.txt >> file1.xls


****** i-- has number of records
******delimiter is " |"


it's return XLS files and open in windows.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script Shell how's converting .html files

Hello everybody, :) I need some help with a school project that I have to create for the next week. :eek: So first, the aim of the Script is that I have a WebSite with a lot of .html / .shtml / .js / .css in one directory. That directory have few directory too but that's not so important,... (1 Reply)
Discussion started by: mariocrocop
1 Replies

2. UNIX for Beginners Questions & Answers

Converting text file to html page

Hello Everyone, I have the following text file with the each field separated by newline Text file P file1-en-us_US-20170718T150157Z.json Wed 19 Jul 2017 06:10:13 AM EDT P file2-en-us_US-20170718T160150Z.json Wed 19 Jul 2017 06:10:13 AM EDT P file3-en-us_US-20170718T163218Z.json Wed... (9 Replies)
Discussion started by: nextStep
9 Replies

3. Shell Programming and Scripting

Converting csv to html format

Below is the code I have - How can I convert the data in the csv into 3 tables in html. instead of 1 table. Attached is the format I am getting. (1 Reply)
Discussion started by: archana25
1 Replies

4. Shell Programming and Scripting

data for spreadsheet

I'm pulling down some LUN usage data once per day. I store the data in a file name that matches the name of the LUN. Then I just append new usage amounts to the same file each day. Filename might be serv01_luna, serv01_lunb, serv01_lunc, etc, etc. Inside the file it would like the following... (7 Replies)
Discussion started by: dwcasey
7 Replies

5. Shell Programming and Scripting

Renaming files based on data in a spreadsheet

I have a spreadsheet in a folder that looks like this: Sector1...Sector2...Sector3...Sector4...Sector5...Sector6...Sector7 SomeID....Title.......SomeID...SomeID....SomeID...SomeID....SomeID OtherID...MyTitle....SomeID...SomeID....SomeID...SomeID....SomeID... (7 Replies)
Discussion started by: Xterra
7 Replies

6. Shell Programming and Scripting

Converting html table data into multiple variables.

Hi, Basically what I am trying to do is the following. I have created a shell script to grab timetabling information from a website using curl then I crop out only the data I need which is a table based on the current date. It leaves me with a file that has the table I want plus a small amount... (2 Replies)
Discussion started by: domsmith
2 Replies

7. Shell Programming and Scripting

Converting html to pdf perl

Hi All, I have a requirement of converting an html form into pdf using perl. The html form contains images, tables and css implementation. I tried using various perl modules but failed to achive the target. I succeeded in generating a pdf from the html file using... (2 Replies)
Discussion started by: DILEEP410
2 Replies

8. Shell Programming and Scripting

Converting a text file to HTML

Hi, I need to convert a text file formatted like this ("tshark -z conv,ip" output) to HTML: ===================================================================================================== IPv4 Conversations Filter:<No Filter> | <- ... (4 Replies)
Discussion started by: ph0enix
4 Replies

9. Shell Programming and Scripting

Converting Shell Script to HTML

Hi, Im new to shell scripting. My task is to convert shell script feed into html, so basically I have a lot of information in shell script and I want to convert it html. I know you can simply convert the information by hand, but is there any simpler way? Thank you Dave (3 Replies)
Discussion started by: davwel
3 Replies

10. UNIX for Dummies Questions & Answers

Converting HTML to CSV

Hi, I need to convert a relatively large html file (1.5megs) into CSV under Unix. How would I be able to do this? Much thanks. (3 Replies)
Discussion started by: Jexel
3 Replies
Login or Register to Ask a Question