Does anybody have a solution for loading a Excel protected sheet (without having to unprotect it) in CT because loading it produces the following error:

Could not load table from disk.

Thanks in advance.

Robert

@Robert Brilmayer

How big is the protected sheet? You can copy the entire sheet and do a paste over to the table in Apptio.

With the table checked out and at the Upload pipeline step, right click on the date where you want to load and select 'Paste Over'. Then paste the entire content in the pop up window and then click 'OK'.

------------------------------
Tony Wong
ExxonMobil TBM Consultant

Original Message:
Sent: 06-19-2023 05:51
From: Robert Brilmayer
Subject: Loading Protected Sheet (Excel) in CT

Does anybody have a solution for loading a Excel protected sheet (without having to unprotect it) in CT because loading it produces the following error:

Could not load table from disk.

Thanks in advance.

Robert

Hi Tony,

It's not a solution, there are more than 30 data sets. 

And multiple sheets and we would like to automate this because of the volume.

If I copy paste the sheet to a new sheet in the same file it works fine, but doing this every month more than 30 times, is not going to work.

Thanks for your trouble.

Robert

@Robert Brilmayer

How big is the protected sheet? You can copy the entire sheet and do a paste over to the table in Apptio.

With the table checked out and at the Upload pipeline step, right click on the date where you want to load and select 'Paste Over'. Then paste the entire content in the pop up window and then click 'OK'.

------------------------------
Tony Wong
ExxonMobil TBM Consultant

Original Message:
Sent: 06-19-2023 05:51
From: Robert Brilmayer
Subject: Loading Protected Sheet (Excel) in CT

Does anybody have a solution for loading a Excel protected sheet (without having to unprotect it) in CT because loading it produces the following error:

Could not load table from disk.

Thanks in advance.

Robert

@Robert Brilmayer we implemented MIP last November and ran into the same issue (and opened a ticket with Apptio).   The only workaround we found was changing the file type to csv.   When the file type was set as csv we did not get the disk error.   Otherwise, I'm not sure Apptio has a solution.   We used another tool prior to MIP and never had this issue but when implementing MIP we ran into this.  

Hi Tony,

It's not a solution, there are more than 30 data sets. 

And multiple sheets and we would like to automate this because of the volume.

If I copy paste the sheet to a new sheet in the same file it works fine, but doing this every month more than 30 times, is not going to work.

Thanks for your trouble.

Robert

@Robert Brilmayer

How big is the protected sheet? You can copy the entire sheet and do a paste over to the table in Apptio.

With the table checked out and at the Upload pipeline step, right click on the date where you want to load and select 'Paste Over'. Then paste the entire content in the pop up window and then click 'OK'.

------------------------------
Tony Wong
ExxonMobil TBM Consultant

Original Message:
Sent: 06-19-2023 05:51
From: Robert Brilmayer
Subject: Loading Protected Sheet (Excel) in CT

Does anybody have a solution for loading a Excel protected sheet (without having to unprotect it) in CT because loading it produces the following error:

Could not load table from disk.

Thanks in advance.

Robert

Hi Tony,

It's not a solution, there are more than 30 data sets. 

And multiple sheets and we would like to automate this because of the volume.

If I copy paste the sheet to a new sheet in the same file it works fine, but doing this every month more than 30 times, is not going to work.

Thanks for your trouble.

Robert

@Robert Brilmayer

How big is the protected sheet? You can copy the entire sheet and do a paste over to the table in Apptio.

With the table checked out and at the Upload pipeline step, right click on the date where you want to load and select 'Paste Over'. Then paste the entire content in the pop up window and then click 'OK'.

------------------------------
Tony Wong
ExxonMobil TBM Consultant

Original Message:
Sent: 06-19-2023 05:51
From: Robert Brilmayer
Subject: Loading Protected Sheet (Excel) in CT

Does anybody have a solution for loading a Excel protected sheet (without having to unprotect it) in CT because loading it produces the following error:

Could not load table from disk.

Thanks in advance.

Robert

Hi Robert,

Do you have SQL team to assist you in this situation? We use SQL SSIS solution to import Excel spreadsheets from file shared location and then create automated SQL batch jobs to export data into csv files that would solve the protected sheet problem.

Hi Tony,

It's not a solution, there are more than 30 data sets. 

And multiple sheets and we would like to automate this because of the volume.

If I copy paste the sheet to a new sheet in the same file it works fine, but doing this every month more than 30 times, is not going to work.

Thanks for your trouble.

Robert

@Robert Brilmayer

How big is the protected sheet? You can copy the entire sheet and do a paste over to the table in Apptio.

With the table checked out and at the Upload pipeline step, right click on the date where you want to load and select 'Paste Over'. Then paste the entire content in the pop up window and then click 'OK'.

------------------------------
Tony Wong
ExxonMobil TBM Consultant

Original Message:
Sent: 06-19-2023 05:51
From: Robert Brilmayer
Subject: Loading Protected Sheet (Excel) in CT

Does anybody have a solution for loading a Excel protected sheet (without having to unprotect it) in CT because loading it produces the following error:

Could not load table from disk.

Thanks in advance.

Robert

Does anybody have a solution for loading a Excel protected sheet (without having to unprotect it) in CT because loading it produces the following error:

Could not load table from disk.

Thanks in advance.

Robert

Hi Robert,

I dare say you may not have an easy way around the data protection as Apptio would require the credentials/access rights to read the data if it is locked down. I am guessing there is a reason for the file to be protected in the first instance.

The other option you could consider is writing a Macro that sits in the Excel file that pushes the data into Apptio via the API. This would overcome the challenge you talk of but would require some VB coding. If you need a pointer I can dig up some old code I wrote that was able to pull data into Excel - with a bit of engineering you could look to use this as a basis to push data back out again and automate over the sheets.

Regards Mark

Does anybody have a solution for loading a Excel protected sheet (without having to unprotect it) in CT because loading it produces the following error:

Could not load table from disk.

Thanks in advance.

Robert

Only a small section of the sheet is protected. 

But this stops the complete load of the sheet.

So have to perform a copy past in a new empty sheet to make it possible to load the data into apptio.

But doing this for 60+ sheets (* 12 months) is too much.

Have to meet with the customer and find another solution.

Thanks,

Robert 

Hi Robert,

I dare say you may not have an easy way around the data protection as Apptio would require the credentials/access rights to read the data if it is locked down. I am guessing there is a reason for the file to be protected in the first instance.

The other option you could consider is writing a Macro that sits in the Excel file that pushes the data into Apptio via the API. This would overcome the challenge you talk of but would require some VB coding. If you need a pointer I can dig up some old code I wrote that was able to pull data into Excel - with a bit of engineering you could look to use this as a basis to push data back out again and automate over the sheets.

Regards Mark

Does anybody have a solution for loading a Excel protected sheet (without having to unprotect it) in CT because loading it produces the following error:

Could not load table from disk.

Thanks in advance.

Robert

What type of protection is on the sheet?

I tested protecting a sheet and it worked just fine.  That being said, have you tried making another sheet that simply uses cell references to the locked sheet, then pointing the upload to that sheet name.  Do you have a sample locked sheet that reproduces this?  Or the steps you're using to lock your sheet in this way?

I locked a sheet, leaving everything unchecked, and was able to load it without issue, with or without using a password.

Original Message:
Sent: 06-23-2023 03:31
From: Robert Brilmayer
Subject: Loading Protected Sheet (Excel) in CT

Only a small section of the sheet is protected. 

But this stops the complete load of the sheet.

So have to perform a copy past in a new empty sheet to make it possible to load the data into apptio.

But doing this for 60+ sheets (* 12 months) is too much.

Have to meet with the customer and find another solution.

Thanks,

Robert 

Original Message:
Sent: 06-23-2023 01:56
From: Mark Johnson
Subject: Loading Protected Sheet (Excel) in CT

Hi Robert,

I dare say you may not have an easy way around the data protection as Apptio would require the credentials/access rights to read the data if it is locked down. I am guessing there is a reason for the file to be protected in the first instance.

The other option you could consider is writing a Macro that sits in the Excel file that pushes the data into Apptio via the API. This would overcome the challenge you talk of but would require some VB coding. If you need a pointer I can dig up some old code I wrote that was able to pull data into Excel - with a bit of engineering you could look to use this as a basis to push data back out again and automate over the sheets.

Regards Mark

------------------------------
Mark Johnson
Delivery Manager - TBM Office
Origin Energy
+61 467 863 134
mark.johnson1@origin.com.au

Original Message:
Sent: 06-19-2023 05:51
From: Robert Brilmayer
Subject: Loading Protected Sheet (Excel) in CT

Does anybody have a solution for loading a Excel protected sheet (without having to unprotect it) in CT because loading it produces the following error:

Could not load table from disk.

Thanks in advance.

Robert