76
Living Room / How to automatically generate reports based on xls files?
« on: February 18, 2019, 10:17 AM »
Hello!
I have an MS Word document that I want some fields to be pulled from an xls file stored in a server.
For example:
1) a field would be the total number of lines of the xls apart from the header
2) a field would be the number of lines that the field under a specific header is the same as one or two values
3) a field would be the percentage of the above number of lines to the total number of lines
Do you know how to implement these? Is there an easy way?
I can do it in other tools if more easy, but they have to be part of MS OS, like Powershell, MS Office, etc.
Thanks!
I have an MS Word document that I want some fields to be pulled from an xls file stored in a server.
For example:
1) a field would be the total number of lines of the xls apart from the header
2) a field would be the number of lines that the field under a specific header is the same as one or two values
3) a field would be the percentage of the above number of lines to the total number of lines
Do you know how to implement these? Is there an easy way?
I can do it in other tools if more easy, but they have to be part of MS OS, like Powershell, MS Office, etc.
Thanks!