Spreadsheets by Script

[g5 Molinengo]

Hi, I created a script that I created a spreadsheet of my reading files in the project. I now have the ncessit? sub lines for condensate field file. Anyone have any idea how to do it?

thanks Piero

[Hippocode]

What exactly is your question ?

So you have a working script that created and filled a worksheet right ? And next ?

[g5 Molinengo]

You just fill up the sheet with the fields of the file I want to get Soloi sub total field type. I think I found the solution. I enclose a piece of script tell me if it is right

SetWSCellTextFormat (tempHandle, 3,1,3,1, ID_font, 9.0);

SetWSCellNumberFormat (tempHandle, 3,1,3,1,1,0,'','');

SetWSCellBorder (tempHandle, 3,1,3,1, TRUE, TRUE, TRUE, TRUE, FALSE);

SetWSCellFormula (tempHandle, 3,1,3,1, '= ('' hardware''.'' Type'')');

SetWSCellTextFormat (tempHandle, 3,2,3,2, ID_font, 9.0);

SetWSCellNumberFormat (tempHandle, 3,2,3,2,2,0,'','');

SetWSCellBorder (tempHandle, 3,2,3,2, TRUE, TRUE, TRUE, TRUE, FALSE);

SetWSCellFormula (tempHandle, 3,2,3,2, '= ('' hardware''.'''' Pieces Total)');

SetWSColumnOperators (tempHandle, 3, -1,0,0,1,0,0); {ordino the first column and condeso data by type}

Hello

? thanks Piero

[Hippocode]

From what I understand, your script makes a database row, adds the titles and borders and sorts the databaserow according to the chosen columns.

Do you get any errors ?

SetWSColumnOperators is the right function to sort your columns. Just make sure ROW 3 IS a database row, and that it has CRITERIA to find all it's sub elements

[g5 Molinengo]

Do not I have no error function SetWSColumnOperators is what I was looking

thanks Piero