question

VeerabaghuMeenaKumari-0516 avatar image
0 Votes"
VeerabaghuMeenaKumari-0516 asked vipullag-MSFT commented

Microsoft HPC Pack

Is it possible to recalculate the entire Excel workbook placed at shared network path using Compute node, and save it back to shared network path?
When a request is received, Is there a way to open the Excel workbook present in shared network path in a write mode by the cluster compute nodes?

azure-hpc-pack
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@VeerabaghuMeenaKumari-0516

Just checking in if you got a chance to see answer provided by Yutong.

Please 'Accept as answer' if it helped, so that it can help others in the community looking for help on similar topics.

0 Votes 0 ·
YutongSun-5052 avatar image
0 Votes"
YutongSun-5052 answered

Hi Veerabaghu,

The built-in Excel service does not support this. You may check the following docs for how to make a custom Excel service for this purpose.
http://216.251.97.10/sampletutorial7.htm
http://216.251.97.10/sampletutorial8.htm

When writing back to the Excel workbook on the share, just make sure there is no confliction from all compute nodes. Also curious why returning the calculation results to the client does not work for you.

Regards,
Yutong Sun

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VeerabaghuMeenaKumari-0516 avatar image
0 Votes"
VeerabaghuMeenaKumari-0516 answered vipullag-MSFT commented

Hi ,

For the calculation on client part , we cannot modify the workbook to include the HPC related macros. The workbook needs to be recalculated by HPC compute nodes which would be triggered by our C# client application.

Our workbooks usually will not have same calculations with different input data, instead it has different formulas at different cells, hence we are looking for a solution to programmatically change the values in few cells of the worksheet, recalculate and save the workbook using HPC.

Regards,
Meena

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If so, you may need a custom excel service or just your c# client app to update, calculate and save the workbook on each compute node.

0 Votes 0 ·

@VeerabaghuMeenaKumari-0516

Just checking in if you got a chance to see answer provided by Yutong.

Please 'Accept as answer' if it helped, so that it can help others in the community looking for help on similar topics.

0 Votes 0 ·