Filter in Mumps Routine for Excel Spreadsheet File
Hi,
Is there a way to filter in a routine for a type of filtering column in Excel. I can apply exclusion logic, but wondered if there was some type of method that accomplished a type of filter.
Thanks
Product version: IRIS 2021.1
I have been creating full blown Excel files for years. I am not sure what our comment 'Filter' means.
My concept is that I have a library of code that reads a template of data that creates the Excel file. Thus all my Report codes generate the Templates then evoke the Excel generator. There is only one generator thus only one place to make any changes that might be inherited from Microsoft.
So can you restate you querey. what are you lookig for?
Hi There,
What I meant by filter is similar to the filters in Excel where a sort can be specified as an example. In my routines, I take a delimited file and then can manipulate the logic based on the request. The file can be created in Excel format. Is this what you mean that you take files for use in Excel?
thanks
what I understand from your description:
This is all standard SQL and fully included IRIS (MUMPS was almost stone-age)
The only question left is your input format as Excel has a proprietary format,
but reads many others as well (CSV, HTML, XML, ..??)