Create Excel workbook - VisualCron - Forum

Community forum

michaelhum
2018-09-24T00:11:22Z
Hi,
I'm trying to add a new spreadsheet to an existing spreadsheet to create a workbook. Each spreadsheet on its own tab (sheet1, sheet2). I cant create the workbook.

This is what I'm doing.

1. Using a spreadsheet named test.xls. It contains a single column of numbers (general cell formatting). The spreadsheet tab name is sheet1
2. Reading a CSV file named input.csv with the READ FILE task
3. Storing the output from the READ FILE task to a variable named newData
4. Using the SET CELL task to create the sheet2 spreadsheet

Setting for SET CELL task
1. Source:
{JOB(Active|Variable|newData)}

2. File filter:
Folder
C:\docs\test

Include file mask
*.xls

3. Target:
Use specific worksheet: sheet2

Cell coordinates
Cell by reference
A1

4. Output
Use same folder but use file mask
File mask *.test.xls

It produces a spreadsheet named test.test.xls The spreadsheet is blank.

what am I doing wrong??









Support
2018-09-25T09:28:38Z
File name seems alright given the settings you use. About being blank I suggest you try to;

1. hard code a value to see that that part works
2. write the Variable to file in the same Task to see you have something in it
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
michaelhum
2018-09-25T15:09:21Z
Originally Posted by: Support 

File name seems alright given the settings you use. About being blank I suggest you try to;

1. hard code a value to see that that part works
2. write the Variable to file in the same Task to see you have something in it



Hi,
I did some more trial and error, using your suggestions.

1. I can create a new spreadsheet with the SET CELL with either a variable or hard coded value as long as the File Filter setting, Include file mask is coded with a file that does not exist. When I code it with a file that does exist, I get a blank file.

Example
1. Source:
Input value
{JOB(Active|Variable|excelOutput)}

2. File filter
Folder
c:\docs\test

Include file mask
test.xls

Output is blank

If I delete the physical file test.xls, but specify it in the "include file mask", a new spreadsheet named test.txt is created with the contents of {JOB(Active|Variable|excelOutput)}. Positioning of the contents is correct. Spreadsheet tab name is correct too. It seems SET CELL can create a new spreadsheet, but it cant add to an existing spreadsheet.




Support
2018-09-26T14:32:17Z
Please zip the following and send it to support@visualcron.com:

1. existing file
2. job settings with Set cell (overwrite)

Make sure the output is in the Job Variable.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top