Request improvement to Dataplugin workbook Cellblock Read

[Pesmith8]

Hello to whom it may concern,

Just completed two Dataplugins using the Dataplugin workbook/spreadsheet object. 

Some areas were found that would have been helpful to have.

1) When using the Cellblock to read a column into a channel. The excel cells that were in column had some cells(in numeric column eR64) that were blank, and some that contained text  -1.#IND   The behavior of the cellblock read was to make the Blanks to be No Values and the -1.#IND to be zero values.  Either way it was unclear what would be put into channel values based on errors in the cells.

Suggest putting in parameter that would direct how blank values are to be handled(zero or Novalue)    As well as how non-numerics would be handled when detected in Cellblock read. 

2) The cellblock read is given a starting cell in column, but it is unclear when the cellblock read will end.  Please give option to explicitly set the end cell location or to give details in help that convey when the cellblock will stop scanning.

3) Would also appreciate making the Cellblock to read a Row as well as the current Column Read.

Paul

[usac · Accepted solution]

Hi Paul,

thanks a lot for your feedback.

Maybe the following can help with some of your topics:

1) Empty cells are always returned as No Values. In addition, you can specify a certain text to be interpreted as No Value by setting the string as follows:

Workbook.Formatter.NoValueSign = "-1.#IND"

2) The cellblock reads to the last row of the sheet. You can query that row by calling 

oCurrSheet.MaxPosition.Column

You can set the length at the cellblock itself:

oCellblock.BlockLength = 10

[Pesmith8]

USAC,

Thanks for the good information, that helped a lot!

It allows me to make the Dataplugin so that I know what the cell scan range is, as well as know how it will handle the cells that are awkward.

Paul