There is such a consideration i forgot to mention: this is a dynamic process, eg, each time the user does such a import, he sets new initial and final months.
Thus, i should have all corresponding properties declared, while having some sort of control on which columns to render. Which property attribute(s) should i use for the control? Kevin, this excel import task happens many times in a month. Each file has plenty of rows, thus the user could not mark each target row as "import this", in risk of become tired and rejecting the application. Thanks 2017-04-13 13:28 GMT-04:00, L Eder <[email protected]>: > 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. >
