EDUCAÇÃO E TECNOLOGIA

‘FilterDatabase’ issue when using Excel Interface I_OI_Spreadsheet

When the program use method ‘GET_RANGES_DATA’ of Interface ‘I_OI_SPREADSHEET’ to get cell contents from one worksheet of excel file, it may select more cells at object ‘soi_range_list’  than your expected.

The extra range has been selected named as worksheet name concatenated with ‘_FilterDatabase’ like below:

The extra cell range comes from the filter functions added inside that specific excel worksheet.

Even if you remove the filters at this specific worksheet, still method ‘GET_RANGES_DATA’ will fetch those cells. Don’t know if it’s caused by Excel store those hidden ranges somewhere or not.

Two options I find out :

  • Copy the contents of this specific worksheet (contains Filter) and paste into the new worksheet without a filter to replace the old one, then it’ll running perfectly.
  • Another way to prevent extra selection may delete the range which name ending with ‘_FilterDatabase’.

Hope it helps if you encounter the same issue and please add comments if you have a better approach : )