Writing ASP code using interop, and the following VBScript is not working correctly. I am unable to find the guidance I need in the documentation.
I simply want to set the bottom border of the top row to a medium black line.
Can you help?
Set xls = Server.CreateObject(“Aspose.Cells.Workbook”)
Set sheet = xls.worksheets.item(0)
Set cells = sheet.cells
set range = sheet.cells.createrange(“A1”,“E1”)
range.setOutlineBorders_2 array(0,2,0,0), array(0,0,0,0)
Result: Invalid_procedure_call_or_argument: range.setOutlineBorders_2
Thank you.
Hi,
Thanks for using Aspose.Cells.
We do not recommend
users to use Aspose.Cells directly from ASP or VB script, instead we recommend you to
make some wrapper assembly around Aspose.Cells yourself and then
use your own wrapper assembly.
For example, in your wrapper assembly, you can write a code like
void ProcessMyData()
{
//write all aspose.cells related code inside it.
}
then from ASP, you can call ProcessMyData() and process everything inside it.
You can research on internet how you can create such a wrapper assembly which could be used in ASP.
Besides, we now recommend ASP users to use Aspose.Cells for Cloud (REST based
APIs). Because these APIs can be used in any platform and languages.
Please also read the following product pages to get familiar with the Cloud APIs.