Extracting the data from web form to Excel sheet

excel
uiautomation

#1

I have a PHP form which contains a comment section . I want each line in the comment section to be stored in the seperate column of the excel sheet. Every time the PHP form is submitted this excel sheet Should be updated. Please suggest how do I do it ?


#2

You can use Get Text activityto copy your Comment info to a String.

Split your string based on Environment.NewLine or any other delimiter

Split(strComments,Environment.NewLine)

Get you pre exisiting excel data to a datatable. using read range.

User Add DataRow to add your strings to respective columns of DataTable.