I am in the process of porting over some VB code that was using MS Excel and is now using Aspose.Excel. I am having some difficulty converting the following so I was hoping you could point me in the right direction:
Dim xlSheet AS Excel.WorksheetWith xlSheet
End WithEnd With
I think the same can be achieved in Aspose.Excel by importing Aspose.Excel and declaring “Dim xlSheet as Worksheet”.
What I am trying to do is use the:
and Style.HorizontalAlignment = TextAlignmentType.Left
In order to achieve the same effect of setting number formats and alignments over a range, but I’m not too sure how Aspose’s range works, could you tell me what would deliver equivalent functionality in Aspose to the code snippet above?
(On a side note my code never looks right when I copy it into this forum! It appears fine for me but when I preview the post it gets a bit bunched up like the 2 End With statements in this example, no matter how many lines I put between them they still show up as you see them now!)