Exporting Lotus Notes data to Excel

We maintain an incident log of computer problems. Each record is on date/time. There is one long description field. Each week I export the previous week's data to Excel to print as a management report. If I export as csv, the long description is truncated when it exceeds a certain length, and sometimes the gridlines cut the top or bottom text in cells. Neither occurs when I export as .wks but at the end of each cell I get a non printable character rectangle which does indeed print. This can be removed with Excel's CLEAN function, but I have not worked out how to use this function on an entire worksheet. Have you any suggestions on the export that may assist.
I tried this out myself and had the same problem exporting to the Lotus 1-2-3 format. I also found the solution. Make sure to specify the filename when exporting to 1-2-3 format including the extension .wk4. I found the solution using http://www.support.lotus.com . Try searching for 802564910029BEB5.
This was last published in April 2002

Dig Deeper on Domino Resources - Part 5

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...