Re: Selective excel import columns

2017-04-13 Thread Dan Haywood
Hi Eder, Interesting use case. How about this design: have a parent view model which has a collection of child view models. The parent will hold the start and end months, eg July to October. The child will have properties for every month, though we populate those from the spreadsheet. To render

Re: Selective excel import columns

2017-04-13 Thread L Eder
Yes Kevin i could implement that dialog using the new collection parameter feature, available in Isis release v1.14.0. On Apr 13, 2017 1:57 PM, "Kevin Meyer" wrote: > Hi Eder, > > Since you clarified the data layout (I somehow assumed the months would be > in rows), the "simple" alternative is f

Re: Selective excel import columns

2017-04-13 Thread Kevin Meyer
Hi Eder, Since you clarified the data layout (I somehow assumed the months would be in rows), the "simple" alternative is for the user to delete the unwanted columns in the worksheet before import, then the parser could use the column name. I assume that you have considered that and discarded

Re: Selective excel import columns

2017-04-13 Thread L Eder
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 att

Re: Selective excel import columns

2017-04-13 Thread L Eder
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, Par

Re: Selective excel import columns

2017-04-13 Thread Kevin Meyer
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 "

Re: Selective excel import columns

2017-04-13 Thread Dan Haywood
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

Selective excel import columns

2017-04-12 Thread L Eder
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