We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to use the class properties in Lotus Script (Utilize Aspose.Cells in other Programming Languages )

Aspose.Cells Product Family
#1

Hi,

How to Utilize Aspose.Cells in other Programming Languages?

Is there any documentation for methods that can be used in other languages?

example: in Vb - PutValue method in cell class is used for updating a cell value. The same method is not working in Lotus script, for that we have to use cell.PutValue_4

Even if we convert the Vb code to Lotus Script the code will not work, as the exact methods are not used.For example: formatting a cell style "cell.setStyle" method is used and this is not working in Lotus notes. To use the same in LS I donot know what suffix to put and so Im randomly trying _2,_4...

Thanks,

Naresh

#2

Hi,

Well, Aspose.Cells for .NET can be used through COM. Please check the following documentation topic for your need:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/accessing-component-from-com-clients.html

Since Cell.PutValue method is an overloaded method and has a long list of overloaded versions, so, in other languages like vbscript, javascript lotusscript etc. this method will be splitted to number of methods e.g.., Cell.PutValue_1, Cell.PutValue_2, Cell.PutValue_3, Cell.PutValue_4, Cell.PutValue_5 etc. If you are putting a simple string value, you may try to use as Cell.PutValue_5("hello world!")

Thank you.

#3

Hi,

I got ur point on how to use the Aspose methods in other languages. Thanks.

My next question is where can I find documention for all the methods that Aspose.Cells uses (for other languages).

For example I'm not sure on where to use Cell.PutValue_1, Cell.PutValue_2, Cell.PutValue_3, Cell.PutValue_4.. I know only Cell.PutValue_5 and that too you have said. The link that you have sent shows only the examples. But I need all the info regarding the methods.

My requirement is to do the below formatting on the excel that is to be generated. (code in lotusscript)

FormatSheet:
xlApp.Rows("1:1").Select
xlApp.Selection.Font.Bold = True
xlApp.Selection.Font.ColorIndex = 3
xlApp.Selection.Interior.ColorIndex = 8
xlApp.Rows("1:"& row%).Select
xlApp.Selection.Font.Name = "Arial"
xlApp.Selection.Font.Size = 8
xlsheet.Columns("AF").ColumnWidth = "55"
xlsheet.Columns("AF").WrapText = True
xlsheet.Range("A:AX").Columns.AutoFit
xlsheet.PageSetup.Orientation = 2
xlsheet.PageSetup.LeftMargin = "0"
xlsheet.PageSetup.RightMargin = "0"

If there is some documentation, it would be helpful for me to refer and code the above using Aspose methods or it will be a overhead for me to post the codes similar to above in the forum and ask for the alternate aspose methods.

Hope you got my issue.

Thanks

#4

Hi,

Well, for your desired functionality, I think you may try to check the following documentation topics which may help you to implement your requirements. The code provided there is obviously in C# and VB, so you may write code yourself for other languages like vbscript, lotusscript etc.

Managing Row/Column:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/insertingdeleting-rows-and-columns.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/copying-rows-and-columns.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/adjusting-row-height-column-width.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/autofit-rows-columns.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/formatting-rows-columns.html

Formatting:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/approaches-to-format-data-in-cells.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/dealing-with-font-settings.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/configuring-alignment-settings.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/formatting-selected-characters-in-a-cell.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/colors-background-patterns.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/named-ranges.html

PageSetup:

Check the doc topics in the section:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/page-setup-features.html

Thank you.

#5

Hi,

Please download the attached .zip file which includes the latest Aspose.Cells for .NET version 4.6.0.4 and the corresponding TLB file for your requirement.

Please view/browse the TLB file, you may use the Microsoft OleView tool (oleview.exe command line utility). The easiest way to download it is from: http://www.microsoft.com/downloads/details.aspx?FamilyID=9D467A69-57FF-4AE7-96EE-B18C4790CFFD&displaylang=en.

For the overload methods, you can easily check the description and other info for the overloaded method versions described with the suffix in the format such as, e.g.., Method_Name, Method_Name_2, Method_Name_3, Method_Name_4 and so on..... Please go through the complete details for Aspose.Cells APIs i.e.., the attributes, methods, enums, structs, classes/interfaces etc. for your need.

Also, you can directly use Visual Studio to open the tlb file and view the corresponding details including interface definitions.

Thank you.