How to manage external data ranges and their properties in excel

Aspose.Cells Product Family
1

Hello,

How to access external data ranges and their properties using Aspose?

Actually, i have added a pictue from Web using aspose in my Excel sheet.

Now i want to Uncheck the External Data Range Properties (Adjust Column Width)

and check the property (Preserve Cell Formating).

How to do this using Aspose?

Please let me know.

Thanks,

Rohan

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please provide us your desired/expected output xls/xlsx file, you can create manually using Ms-Excel and also provide us screenshot with red circles around the area of interest which should illustrate your requirements.

We will look into your issue asap and provide you a code example.

3

Hi,

I have attached a document with screen shots.

Let me know if you need anything more.

Please give me a solution for this.

Thanks,

Rohan

4

Hi,

Thanks for your explanation and providing us the document with screenshots.

After looking into your requirements, I assume, it is a New Feature.

I have logged a new feature request for this issue in our database and forwarded this query to development team. Development team will look into this issue and once this feature is implemented or we have some other update for you, we will let you know asap.


In case, this feature already exists, then we will soon help you with a sample code.

This issue has been logged as CELLSNET-40677.

5

Okay thanks a lot.

Please let me know asap, as i am stuck in between.

Thanks,

Rohan

6

Hi,


This is a new feature that is not supported by Aspose.Cells at present. Our development team will look into it for our future versions.

Thank you for using Aspose.Cells
7

Okay, when will i get this functionality in Aspose?

How much time will it take? Any idea?

8

Hi,


I am afraid we can not provide an ETA for this feature at this time. This is a new feature and will take some time for planning, implementation and testing with the whole API. We will update this thread once we have any such information available.

We appreciate your understanding of the situation, Thanks.
9

Hi,

Please download and try this fix: Aspose.Cells for .NET v7.3.0.3

See the following sample code:


C#
book.Worksheets[0].QueryTables[0].PreserveFormatting = false;
book.Worksheets[0].QueryTables[0].AdjustColumnWidth = false;


10

The issues you have found earlier (filed as CELLSNET-40677) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.