Hey there,
is there any obvious way to make the plugin save excel-specific formatting to the DB (let's say cell color or Comments)? Alternatively, is there any way to save conditional formatting in the spreadsheet so that the formatting is kept when the data is refreshed. For example, I want to highlight cells (or rows) where a cell has a specific value.
Best regards
Excel SQLite and Excel formatting
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Excel SQLite and Excel formatting
Refresh will discard color formatting and delete all comments. We will investigate the possibility to keep the color formatting of cells and cell comments and will post the results here as soon as possible.
Re: Excel SQLite and Excel formatting
Thank you that would be very helpful!
Re: Excel SQLite and Excel formatting
A related question. It seems that there should be a way to do a batch save with the records. Below there is my code for migrating from mdb to sqlite. It is VERY slow saving every record. I tried putting the .UpdateBatch out side of the month loop, but then nothing was saved to the target database. I don't see another way to do it, but the very name of the command makes me think of mass updates. Is that only used for existing record edit updates, but not new record creation?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Excel SQLite and Excel formatting
Please tell us which Devart product you are using. Excel Add-ins are not designed for migrating data between two sources.