Excel VBA => Aspose.Cells Cheat Sheet

Aspose.Cells Product Family
1

Where is the cheat sheet for converting Excel VBA to Aspose.Cells code?


When I replace old Excel Interop dll with Aspose.Cells.dll, many things break.

I need a conversion reference showing old way and new way, side by side.

If I had that, I could just fly through my code and convert it quickly.
As it is now, I have to agonize and think every time and look it up every time.

Thanks.
2

Hi,


Thanks for your query.

We recommend you to kindly see the Wiki Conf. Docs and go through different topics in the relevant sections/ sub sections for your complete reference:
https://docs.aspose.com/display/cellsnet/Home

If you still have any issue for converting specific VBA code segment to Aspose.Cells APIs, please provide more details about the VBA code and paste code segments here with comments, so we could analyze it and help you soon here.

Thank you.

3

The resource you pointed me to is not in the format I need. In fact, this is exactly what I am complaining about. You have just pointed me right back to the thing I am complaining about!


It is too much of you to ask me to:
  • look into each one each time I have 1 line of code to convert.
  • open a ticket orforum question for each line of code I have to convert.
It adds work for you too, having to answer each little question, over and over.

Do you understand what I’m asking for?

If there was a simple list that had two column: Excel VBA and Aspose.Cells, with old method and new method for the top common task on which that you broke compatibility that would speed up conversion of old Excel VBA code.

You know all the places where your API is different from Excel VBA.

Don’t you see my idea, or not?
4

Hi,


Well, I am afraid, there is no such document where we provide two columns in comparisons (one having Excel VBA code and other with relevant Aspose.Cells APIs). We only provide some documents for simple features when migrating from Excel automation to Aspose.Cells APIs here:
http://www.aspose.com/docs/display/cellsnet/Migration+from+Microsoft+Office+Automation+to+Aspose

We are very sorry but you got to sort it yourself for converting your VBA codes to Aspose.Cells APIs. We would surely help you out while converting your VBA codes to Aspose.Cells APIs when you ask us for certain conversions or find any issue when converting your VBA code segments to upgrade to Aspose.Cells API. It does not matter and won’t be an issue for us if you ask us again and again for your conversion issues, this is what we are supposed to do and it is our duty to help the users to figure out their issues.

Thank you.