What began as a powerful tool for self-service data analysis has routinely been abused as an imperfect but ubiquitous stand-in to manage business processes. It’s only too easy to spin up a new Excel sheet, fill it with data and start emailing it back and forth to your colleagues. Because business process is deeply ingrained…
Tag: excel
Import Data From An Excel or CSV to Data Grid Control
In this article, we are going to look at a new feature released as part of AgilePoint NX v9.0 which will enable importing data from Excel or CSV file to a Data Grid. Over the last few years, we have made a lot of investments on the Excel integration which ranges from supporting Excel as…
Import Data From An Excel or CSV to SubForm Control
In this article, we are going to look at a new feature released as part of AgilePoint NX v8.0 Software Update 2 which enables importing data from Excel or CSV file to a SubForm. Over the last couple of years, we have made a lot of investments on the Excel integration which ranges from supporting…
Introducing Excel as a Data Source for Your Applications
In this article, we are going to see how to create AgilePoint NX Apps with Excel as a data source. Many businesses today run significant part of their business on Excel sheets. Even in large enterprises, lot of structured information is stored in Excel files. The problem with using Excel is it doesn’t scale well….
Turn Spreadsheets Into Data Tables with Data Entity
In today’s world of sophisticated software solutions, sometimes it’s those that are simple, yet powerful, that stand the test of time. Since its inception many years ago, Excel has emerged as one of those tools preferred by business users (whether used as intended, or not!). From pivot tables to visualizations, Excel is used pervasively throughout an organization. With…
Read And Write To Excel Tables Using Excel Connector
As the name indicates, this feature allows reading of multiple rows into AgilePoint NX process data and writing back process data into multiple rows of the selected Excel. The operations that happen on the Excel, happen on a specified table in the selected Excel. Prior to this feature being introduced in AgilePoint NX 7.0 SU2,…
Read data from excel sheet and populate on eForms
Sometimes the requirement is to have an AgilePoint eForm in which an Excel file can be uploaded. Once uploaded we need to grab the data in the Excel file and populate it to the different fields in the form. There are N number of ways of doing this based on Effort VS Reusability Vs Customer’s willingness…