Aspose Create Excel Worksheet

GenerateExcel

//sign(), download(), processCommand() part of AsposeService.cls
    public static String generateJunkDataXML (Integer rows, Integer columns) {
        //String xmlString = '<ImportStringArrayOption><DestinationWorksheet>Sheet1</DestinationWorksheet><FirstRow>1</FirstRow><FirstColumn>1</FirstColumn><IsInsert>true</IsInsert><IsVertical>true</IsVertical><Data>';
        String xmlString = '<ImportBatchDataOption><DestinationWorksheet>Sheet1</DestinationWorksheet><ArrayOfCellValue>' ;
        
        for ( Integer row =1;row< rows; row++) {
            //xmlString += '<ImportStringArrayOption><DestinationWorksheet>Sheet1</DestinationWorksheet><FirstRow>1</FirstRow><FirstColumn>'+row+'</FirstColumn><IsInsert>false</IsInsert><IsVertical>true</IsVertical><Data>'   ;
            for ( Integer column=1;column<columns; column++)  {
                //xmlString += '<string>something</string>' ;
                xmlString += '<CellValue>     <rowIndex>'+row+'</rowIndex>         <columnIndex>'+column+'</columnIndex>         <type>string</type>     <value>testing</value>    </CellValue>' ; 
            }
            //xmlString+= '</Data></ImportStringArrayOption>';
        }
        xmlString +='</ArrayOfCellValue></ImportBatchDataOption>';
        //xmlString+= '</Data></ImportStringArrayOption>';//'</ImportStringArrayOptions>' ;
        system.debug ( xmlString );
        return xmlString ;
    }
    
    public static void createXMLWorksheet(String folder, String filename, Id recordId) {
        String endpoint = AsposeApp.baseURL + 'cells/'+ filename +'?&folder='+folder;
        system.debug ( endpoint ) ;
        system.debug ( sign ( endpoint ) );
        processCommand(sign(endpoint), 'PUT');
        
        String xmlString = generateJunkDataXML(10,10);
        endpoint = AsposeApp.baseURL + 'cells/'+ filename +'/importdata?importOption=ImportBatchDataOption&folder='+folder;
        system.debug ( sign ( endpoint ) );
        system.debug ( processCommand(sign(endpoint), 'POST', xmlString, 'xml' ) );
        
        Attachment att = downloadAsAttachment ( folder, filename);
        att.Parentid = recordId ;
        att.Name = filename;
        insert att ;
    }