search results

(...) Hi all! We are using the action 'Invoke REST Web service' a lot, but there are some limitations I am struggling with. I want to download an Excel file using this action, using an external REST service. My first approach was to store the response body into a multi-line content field. I am also using a HTML field with a download button, to save this file from content field to disk. This method is (...)

(...) 1. In Automation (action) I create Excel file from template and add few data to specific cells. 2. The Excel file is attached to the form in attachment section. 3. I would like to create pdf file from that Excel file . (i don't see that option) in design studio. what I would like to do: 0. create template with excel (done) 1. from fields update excel template (done) 2. excel template save as attach (...)

(...) It would be very helpful if excel generating action and data table attribute ability to save as excel could produce an Excel file with or without columns headers. This is sometimes useful, as some external applications accept only data in Excel file s and no headers.

(...) How can I read data from an Excel file containing a macro *. XLSM. This file is not seen by BPS, after changing to *XLSX the data is read correctly.

(...) Hi all, I have a question about exporting data to an Excel file from item list. I want this data to be already sorted after exporting to an .xlsx file. When the data is loaded into the item list it is sorted by webcon, on the form it is ok, but when exporting to excel the data in the .xlsx file is not sorted at all. Any idea how to do this?

(...) Hi Community! Is there any possible ways to start subworkflows from Excel file ? Business case is that, I have MS Excel file with estimated 500 rows. I want to attach sheet to attachments section and start workflow by path or button on menu bar with starting workflow action. Is any way to do it without special SDK customization? Subworkflows should have data from in excel sheet. Every workflow contains (...)

(...) Hi. In one of our processes, a user can import data into an item list from an Excel file . Unfortunately, these files often contain at least 100 items, which causes import problems. In such cases, somehow, the import is successful from the admin level (I don't understand the difference). The item list currently has 40 columns, including several selectable fields that also populate other fields or calculate (...)

(...) Hello, I have a problem that I need to solve and I hope you could help me. The case is that we are collecting data in Excel file s regarding temperature and humidity from devices – these are automatically generated files that land in our mailbox and are then loaded into the workflow. The reading works perfectly if the Excel file contains a table. Does anyone know a way to read data from a range in Excel i (...)