Export to Excel for large values IN A SINGLE CELL

HCL Domino Domino Forum
1

Hi,

there is a view that has a column with the history of the events that had taken place in the document. I want to export that value to excel sheet in a single cell.

My history field is as follows:

By-A on date:status * comment***

By-B on datetime: status

Each is in a new line. When i export this to excel, I am getting the enteries in different cell. But i want this to be exported in a single cell in excel sheet. i used the following command for that history column:

@Implode(@Explode(History; @NewLine); “,”)

In the client its fine, that is, the whole history value is being shown. But when i export it the history is truncated.

Please suggest.

Thanks a lot!

aditi

2

Subject: Export to Excel for large values IN A SINGLE CELL

If you are exporting via the File > Export menu, then you probably have no option to fix that.

However, if you write an agent to export, you can use COM and you can manipulate the data so that a multi-value field can show in one cell in Excel.

It’s a fair bit of code, so indicate if you can use an agent or not.

3

Subject: RE: Export to Excel for large values IN A SINGLE CELL

Hi,

Can u post the code for the agent to run?

Thanks a lott!!