Exporting Lotus Notes data to Excel

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.

    Requires Free Membership to View

    Login

    Register today to access targeted resources from our editorial writers and independent industry experts focused on Lotus Domino, Notes, Workplace and other related technologies.

    By submitting your registration information to SearchDomino.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchDomino.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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 first published in April 2002

Back to top