Discussion Locked

Converting files to jpeg

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

8 replies

by q2ggirl

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.

by robert_a_mocarski

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

by robert_a_mocarski

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.

by tmaclennan

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.

This discussion is closed to new replies.