Microsoft Excel 2010和Python中的受保护的视图 [英] Protected View in Microsoft Excel 2010 and Python

问题描述

此处没有代码示例.刚刚遇到Microsoft Excel 2010的问题，我在linux上有一个python脚本，该脚本从csv文件中提取数据，将数据推送到excel，然后将该文件作为附件通过电子邮件发送到某个电子邮件地址.

No code examples here. Just running into an issue with Microsoft Excel 2010 where I have a python script on linux that pulls data from csv files, pushes it into excel, and emails that file to a certain email address as an attachment.

我的问题是我在excel文件中使用公式，当它第一次打开时，它进入保护视图".单击启用编辑"后，我的公式才会加载.即使启用了保护模式，仍然可以显示我的电话号码吗?

My problem is that I'm using formulas in my excel file, and when it first opens up it goes into "Protected View". My formulas don't load until after I click "Enable Editing". Is there anyway to get my numbers to show up even if Protected Mode is on?

推荐答案

弄清楚了这一点.只是使用了for循环来保持运行总计.对不起，浪费的问题.

Figured this out. Just used the for loop to keep a running total. Sorry for the wasted question.

这篇关于Microsoft Excel 2010和Python中的受保护的视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！