Dear all, i using aspose to instead of my old code whitch using Microsoft .com.
some funtion i don’t know how to change.
like :
Dim os AS Excel.Worksheet
oS.Range(“A55”, “S55”).Select()
oS.Application.Selection.Copy()
oS.Application.Selection.Insert(Shift:=Excel.XlDirection.xlDown)
when i using aspose. i dont know which function can
instead it…Would you mind help me…? please
Hi,
See the sample code segment using Aspose.Cells APIs that you may refer to to accomplish your task.
e.g
Sample code:
'Transpose method.
Dim workbook As New Workbook(“e:\test\syle\template.xlsx”)
Dim cells As Cells = workbook.Worksheets(0).Cells
Dim range As Range = cells.CreateRange(“B1:G1”)
Dim dRange As Range = cells.CreateRange(“B12:B17”)
Dim options As New PasteOptions()
options.PasteType = PasteType.Values
options.Transpose = True
dRange.Copy(range, options)
workbook.Save(“e:\test2\transposepasteere.xlsx”)
Hope, this helps a bit for your needs.
Thank you.