Dan, it would be a range of columns.
I ask in a dialog the initial month and the final month. For example,
a May - August range.
I then would like to import the rows only of those columns, ignoring
thus the remaining months there.
Such a typical excel file worksheet has these columns: Item,
PartNumber, Jan Feb, ...., Dec
So the rendered collection would be with the colums:
Item, PartNumber, May, June, July, August
The data for the remining monh columns would come from another source
- the application database.
2017-04-13 7:32 GMT-04:00, Kevin Meyer <[email protected]>:
> Hi Eder,
>
> I understand that you want to import only selected rows.
>
> As Dan says, I'd like to know why you don't use your external tools (e.g.
> the source spreadsheet) to manage selection.
> Otherwise, it may be a bit of a hack, but maybe you can create a special
> column in your source sheet akin to "import this row", that your import
> module (which uses the excel module component) would use as a filter...
>
> Does this help you in any way?
> Cheers,
> Kevin
>
> On 13 April 2017 09:02:31 CEST, Dan Haywood <[email protected]>
> wrote:
>>Hi Eder,
>>
>>We recently updated the excel module to 1.14.1, and the new version has
>>some improved features which you might want to take a look at.
>>
>>With respect to your question, do you mean a range of rows, or a range
>>of
>>columns?
>>
>>To only process a subset of the columns, I think you just need to not
>>define any corresponding property in the view model handler you are
>>loading
>>into.
>>
>>But if the question is that you want to process a subset of rows, then
>>it's
>>the responsibility of your handler to just ignore the rows that aren't
>>important. There is no mechanism (currently, at least) to import rows
>>1
>>thru 100 only, say.
>>
>>HTH
>>Dan
>>
>>
>>On Thu, 13 Apr 2017 at 02:41 L Eder <[email protected]> wrote:
>>
>>> Hi members:
>>>
>>> I have a sheet that includes the months of year as columns.
>>> I would like to import only a range of those columns, rather all at
>>once.
>>>
>>> Anyone could point me as to do that using the excel isis module?
>>>
>>> Thanks, Eder
>>>
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
