Hi
Can I get the add in to post at a timed interval automatically
Regards
Malcolm Laws
Auto Posting
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Auto Posting
Please describe what you want in more details. Please also tell us which database or cloud source you use.
Re: Auto Posting
Hi
I have an Excel workbook that is reading data from an OPC source. The data is manipulated in the workbook with an add in that calculates energy/steam usage.
I have two cells that are populated that at present are imported into SQL server by copying the file to the server and using SSIS to import into SQL at midnight each day with a time stamp.
I would just like those two readings to be writing to a table but saving the values through out the day with out pressing the commit button. The Excel sheet is open and updating 24hours a day.
Regards
Malcolm
I have an Excel workbook that is reading data from an OPC source. The data is manipulated in the workbook with an add in that calculates energy/steam usage.
I have two cells that are populated that at present are imported into SQL server by copying the file to the server and using SSIS to import into SQL at midnight each day with a time stamp.
I would just like those two readings to be writing to a table but saving the values through out the day with out pressing the commit button. The Excel sheet is open and updating 24hours a day.
Regards
Malcolm
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Auto Posting
If we understand you correctly, you want to commit changes made in Excel to SQL Server automatically by a timer after specified intervals without clicking Commit.
We can add an option for automatic commit after you edit data in a cell and press [Enter] or move to another cell without clicking Commit. Is this solution suitable for you?
We can add an option for automatic commit after you edit data in a cell and press [Enter] or move to another cell without clicking Commit. Is this solution suitable for you?
Re: Auto Posting
Hi
Thank you for your reply.
Sorry I'll try and clear up the data entry. This is an unattended workbook, nobody is actually entering the data. The data is coming in externally form process machines and updating the spreadsheet. I just was hoping that I could just have the data committed by a timer say every hour or whatever is chosen. A bit like you can record a macro to auto save the workbook
Regards
Malcolm
Thank you for your reply.
Sorry I'll try and clear up the data entry. This is an unattended workbook, nobody is actually entering the data. The data is coming in externally form process machines and updating the spreadsheet. I just was hoping that I could just have the data committed by a timer say every hour or whatever is chosen. A bit like you can record a macro to auto save the workbook
Regards
Malcolm
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Auto Posting
We will investigate the issue and post here about the results as soon as possible.