Aspose.Cells.Cell' does not contain a definition for 'Style' in .NET

Aspose.Cells Product Family
1

We have not yet received a response for this solution required . kindly check and rectify my issue. ‘Aspose.Cells.Cell’ does not contain a definition for ‘Style’ and no extension method ‘Style’ accepting a first argument of type ‘Aspose.Cells.Cell’

could be found (are you missing a using directive or an assembly

reference?) .This is the Error arise in the application.

Here i have attached the code that i have used Please check .I mentioned the correct path below ,please check it .

for (int l = 0; l <= ds.Tables[j].Columns.Count - 1; l++)

{

ce[k, l].Style = style;

}

its urgent…

2

Hi,


Thanks for providing us some details.

Well, Aspose.Cells.Cell.Style is obsoleted, you may use Cell.GetStyle() and Cell.SetStyle() methods instead now. Now, you have to call Cell.SetStyle and pass the Style object as parameter to set the style for a cell. Please change the line of code:
e.g
Sample code:

for (int l = 0; l <= ds.Tables[j].Columns.Count - 1; l++)

{

ce[k, l].SetStyle(style);

}


We also recommend you to kindly see the Aspose.Cells for .NET Wiki Conf. Docs for your reference, especially the topics in the section/sub-section:


Let us know if you still have any issue.

Thank you.
3

Thanks for providing us some details. Here I have the code below ,that I have used Please kindly check it. I mention the correct path below ,please check it.

‘Aspose.Cells.Workbook’ does not contain a definition for ‘Open’ and no extension method ‘Open’ accepting a first argument of type ‘Aspose.Cells.Workbook’ could be found (are you missing a using directive or an assembly reference?)

Workbook wb = new Workbook();

wb.Open(Server.MapPath(".") + @"\OMS Enabler\ProjectPrice_SL_FL_Template.xls");

Worksheet ws1;

wb.Open(Convert.ToString(ArPath[fc]));

‘Aspose.Cells.Workbook’ does not contain a definition for ‘ConvertNumericData’ and no extension method ‘ConvertNumericData’

accepting a first argument of type ‘Aspose.Cells.Workbook’ could be found (are you missing a using directive or an assembly reference?)

wbc.ConvertNumericData = true;
4

Hi,


In newer versions, we have obsoleted Workbook.Open method, please use Workbook constructor instead, see the sample line of code here:
e.g
Sample code:

Workbook wb = new Workbook(Server.MapPath(“.”) + @“\OMS Enabler\ProjectPrice_SL_FL_Template.xls”);


For your issue regarding ConvertNumericData, please refer to the following code segment when using newer Aspose.Cells versions:
e.g
Sample code:

LoadOptions retVal = new LoadOptions(LoadFormat.Xlsx);
retVal.ConvertNumericData = true;

Workbook workBook = new Workbook(“e:\test2\TestWorkbook.xlsx”, retVal);

Please refer to the above lines of code and you may write/ change your own codes accordingly.

We highly recommend you see the Aspose.Cells for .NET API Reference here:
http://www.aspose.com/docs/display/cellsnet/Aspose.Cells+for+.NET++API+Reference

Also, see the Programmer’s guide, please go through different topics/ documents or articles on how to implement different features using latest APIs set of Aspose.Cells, so you could change your sample code accordingly:
http://www.aspose.com/docs/display/cellsnet/Aspose.Cells


Let us know if you still find any issue.

Thank you.

5

Thanks for providing us some details. Here I have attached the code that I have used Please kindly check it. I mention the correct path below, please check it .

Error 134 ‘Aspose.Cells.Cell’ does not contain a definition for ‘Style’

and no extension method ‘Style’ accepting a first argument of type ‘Aspose.Cells.Cell’ could be found (are you missing a using directive or an assembly reference?)

WB.Worksheets[0].Cells[Dtki + 1, 1].Style.Font.Underline = FontUnderlineType.Single;
WB.Worksheets[0].Cells[Dtki + 1, 1].Style.Font.Color = Color.Red;
6

Hi,


Well, as I told you that Aspose.Cells.Cell.Style is obsoleted, you may use Cell.GetStyle() and Cell.SetStyle() methods for applying formatting/ style now. See the sample updated lines of code that you may try:
e.g
Sample code:

…
Style style = WB.Worksheets[0].Cells[Dtki + 1, 1].GetStyle();
style.Font.Underline = FontUnderlineType.Single;
style.Font.Color = Color.Red;

WB.Worksheets[0].Cells[Dtki + 1, 1].SetStyle(style).



We again recommend you to kindly see the Aspose.Cells for .NET Wiki Conf. Docs for your reference, especially the topics in the section/sub-section:



Thank you.
7

So what happens to the customers who have the Aspose cell as obsolete , how do they get the new version if they have to upgrade them to site oem or dev oem from small business edt?

8

Hi,


If your clients do not use or upgrade to latest versions of the product and they keep using the older versions of Aspose.Cells for .NET, they would not find any problem. But if they upgrade to latest APIs set of Aspose.Cells, they have to update the code segments accordingly in their project(s). To download latest Aspose.Cells versions, they may get from Downloads module here:
http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/default.aspx

Thank you.

9

Kindly look into this error report and revert back to us soon. pls find attached the same…

10
Hi,

Thanks for the screen shot.

Well, this is a System.IO error which shows that it could not find the license file at your specified path. Please debug your application and make sure that the license file is there in the specified location. The license file (.lic) file is not copied, while publishing the application in the deployment process. So, you would require to manually copy the license file to the target server.

Thank you.