Because the existing system has been upgraded from owc9 to owc11, some minor problems are recorded as follows for your reference:
1. COM component upgrade
The clsid of owc9 is 0002e510-0000-0000-c000-000000000046.
The clsid of owc11 is 0002e559-0000-0000-c000-000000000046, which is directly replaced. Of course, the owc11 component must be installed on the host.
2. Automatic row and column Width Adjustment
Change autofitcolumns () in owc9 to columns. autofit ()
3. Lock Cells
Owc9: spreadsheet1.activesheet. Range (""). freezepanes (X)
Owc11: spreadsheet1.activesheet. Range (""). Select ();
Spreadsheet1.activewindow. freezepanes = true
4. Location
In owc9, The halignment is adjusted to the horizontalalignment of owc11.
The value is constants. xlhalignright, xlhalighleft and so on.
5. Edges
Change the value of borders. linestyle = owclinestylesolid in owc9 to constants. xlcontinuous.
There are some doubts about this. In the owc11 instruction, the owclinestylesolid constant supported by owc9 also has descriptions, but there is always an error in owc11 usage, and you can change it to the xlcontinuous type, I don't know what's going on. I hope I can share it with my friends. Thank you.