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 )

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

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.

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

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.

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.