Free Support Forum - aspose.com

Tracked changes for Excel files

Hi,

I want to know whether ASPOSE.Cells for .net providing any API for tracked changes.

If yes means please provide me the sample code.

Thanks,

Dhivya

Hi,

I am not sure about your requirement. But I guess you are looking for changes inside releases.

Please download the latest version Aspose.Cells
for .NET v5.3.3.5.


At first, you should check the release notes for different
official versions
of Aspose.Cells for .NET (especially v5.0.0 and 5.1.0

etc.) for API changes.

  1. See Release Notes Aspose.Cells for .NET 5.0.0
  2. See Release Notes Aspose.Cells for .NET 5.1.0


Note:
Check the description under “Notable Changes for Existing Users” for API changes.

For older Workbook.Open and Workbook.Save methods, please see the documents for your reference to check what is updated now:

  1. Opening Files
  2. Saving Files

Moreover, please check the documentation of the product for complete details:

  1. Programmer’s Guide

Let me come towards your significant errors that you may encounter, so you can fix them accordingly:

1)
You need to import the relevant namesapaces to your project pages or
use fully qualified naming when declaring objects for classes etc.:

e.g
   <span class="kwrd">using</span> System;<br>
   <span class="kwrd">using</span> System.Web;<br>
   <span class="kwrd">using</span> Aspose.Cells;<br>

   <span class="kwrd">using</span> Aspose.Cells.Pivot;<br>
   <span class="kwrd">using</span> Aspose.Cells.Charts;<br>
   <span class="kwrd">using</span> Aspose.Cells.Drawing;<br>

   <span class="kwrd">using</span> Aspose.Cells.Properties;

etc.


2) As I said above, some classes have been renamed.

e.g

i) Validations --> ValidationCollection
ii) PivotTable --> PivotTableCollection

etc.


3) Aspose.Cells.Style property is eliminated/obsoleted now, you should adjust your code to use Aspose.Cells.GetStyle() and

Aspose.Cells.SetStyle() methods, it will also enhance the performance to
certain extent:

e.g

Your sample code using Style attribute should be updated accordingly, e.g


Style style = wsNdaa.Cells[0, 0].GetStyle();

style.Font.IsBold = true;
   wsNdaa.Cells[0, 0].SetStyle(style);<br>
   Style style2 = cells["I1"].GetStyle();<br>
   style2.HorizontalAlignment = TextAlignmentType.Center;<br>
   style2.BackgroundColor = System.Drawing.Color.Navy;<br>
   style2.Font.IsBold = <span class="kwrd">true</span>;<br>

   cells["I1"].SetStyle(style2);


For complete reference about Cell.GetStyle/SetStyle approach, please see the documents in the section:

  1. Working with Data Formatting


4) And above all, please check Aspose.Cells for .NET API Reference:

Hi,

Actually my requirement is to find programmatically whether the excel document have be modified or not. I want to know ASPOSE.Cells is providing any property to identify whether the changes are tracked when the excel document is edited in Microsoft Excel, like

Aspose.Word for .net having the property "Document.TrackRevisions" to identify if changes are tracked when this document is edited in Microsoft Word.

Thanks,

Dhivya

Hi,

I am afraid, this feature is not yet available. I have added a New Feature Request for this issue in our database. We will let you as soon as possible.

This issue has been logged as CELLSNET-28428.

Hi,

Please download the latest version:
Aspose.Cells
for .NET v6.0.1.7
and see the following code for your requirements.

Workbook.AcceptAllRevisions : Accept all change.

Workbook.HasRevisions : check whether the workbook is tracked.