I tried some method and also already did some research on my problems.
First, I met an error when I was using “Create file” activity to create a new blank Excel file with the present time as my file name.(System.DateTime.Now.ToString(“yyyyMMdd”)EX: 20190620).
Although the file seems to be created, it had some issues showed “Excel cannot open… because the file format or file extension is not valid.”
Second, for testing the next step of my process, I used “Read PDF Text” activity to fetch all the data and stored as rawPDF which is Type “String”.
However, I couldn’t figure out how to put it into an Excel file with the as same format as my PDF file. All the data just stored into only 1 cell at “A1” where I thought it would store the data from “A1” but not just only “A1”.
Does anyone has these experience or idea to deal with it??
Thank for answering