General discussion

Locked

Converting files to jpeg

By MKH@CR ·
I have approximately 900 report files of various formats (xls, txt, rpt) that I want to be able to view on an intranet site. Some are a page or 2 others are much longer. Is there an easy way to convert this to jpg format?

This volumn is a one time effort to get the site up and running.

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Converting files to jpeg

by Q2Ggirl In reply to Converting files to jpeg

You can take a screen shot of the spreadsheet.

For example, open excel, open the document and press CTRL-PRINT SCREEN simultaneously.

Then open paint and copy and paste it in the window.

Then you can save as and save it as a jpeg.

Collapse -

Converting files to jpeg

by Shanghai Sam In reply to Converting files to jpeg

Poster rated this answer

Collapse -

Converting files to jpeg

by robert_a_mocarski In reply to Converting files to jpeg

I am not aware of any utility that will mass convert those files to jpg files, so you are probably looking at a manual process. Is getting them in a jpg format the goal, or just to get the info out on the site?

If you just need to get them on thesite, an alternative may be to import those files into a database (Access or SQL Server) and then write a scripted webpage using ASP or Coldfusion to display the data on the webpage. This would work very well for reports that are text only.

Import each report into a separate table, and you can reuse the webpage code merely by changing the table name in the SQL code. For spreadsheets that contain graphs, etc, use the save as HTML feature in Excel.

Following is ASP code to read an Access dband display the results:

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("/path/database.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open strConnect
sqlCommand = " SELECT table.* FROM table " _ & "WHERE [table]![field] = value"
Set dbRs = Conn.Execute(sqlCommand)
If Not dbRs.BOF Then
Do While Not dbRs.EOF
rsfieldName = dbRS.Fields("fieldname")
Response.Write(rsfieldname)
Loop
End If
Conn.Close
Set Conn = Nothing

Collapse -

Converting files to jpeg

by robert_a_mocarski In reply to Converting files to jpeg

I like the pdf solution as well. Acrobat includes a batch function that may do the trick. Acrobat 4.05 includes filters for Framemaker, txt, html, wordperfect, excel, powerpoint, word, and a variety of image files. I've never used the batch functionand couldn't get it to work in testing, but it might do the trick for you. Downside to using this solution would be the licensing cost for Acrobat.

Collapse -

Converting files to jpeg

by Shanghai Sam In reply to Converting files to jpeg

This suggestion was a litle more robust than I needed. But it was a good idea.

Collapse -

Converting files to jpeg

by tmaclennan In reply to Converting files to jpeg

I like the second answer, but another way would be to get Adobe Acrobat and output everything into PDF format. This would allow indexing, searching, etc. thtat .jpg format would make impossible.

Collapse -

Converting files to jpeg

by Shanghai Sam In reply to Converting files to jpeg

Poster rated this answer

Collapse -

Converting files to jpeg

by MKH@CR In reply to Converting files to jpeg

This question was closed by the author

Back to Web Development Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums