Split Excel Worksheets into New Workbooks and to any Image Format using Cl

Split Excel Worksheets into New Workbooks and to any Image Format using Cl

#######
Section 1 ######
app_sid = '####### Section 1 ######
app_sid = '77******-1***-4***-a***-80**********'
app_key = '*********************'
Aspose::Cloud::Common::AsposeApp.new(app_sid, app_key)
#build URI to split workbook
str_uri = 'http://api.aspose.com/v1.1/cells/Sample.xlsx/split?format=png';
#uncomment following line to split specific worksheets
#str_uri = 'http://api.aspose.com/v1.1/cells/Sample.xlsx/split?from=2&to=3&format=tiff';
#sign URI
signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri);
#######
End Section 1 ######
#######
Section 2 ######
#Split spreadsheet file
response_stream = RestClient.post(signed_uri, '', {:accept=>:json})
#######
End Section 2 #####

#Download Split Files

stream_hash = JSON.parse(response_stream)
stream_hash['Result']['Documents'].each do |document|

       #Build and sign URI to download split files

file_name = File.basename(document['link']['Href'])
str_uri = 'http://api.aspose.com/v1.1/storage/file/' + file_name;            
signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri);

file_name = File.basename(str_uri)

      #Download and save split files

response_stream = RestClient.get(signed_uri, :accept => 'application/json')
      Aspose::Cloud::Common::Utils.save_file(response_stream, file_name)

End


Learn More :