首页   注册   登录

fzinfz

V2EX 第 114172 号会员,加入于 2015-04-29 18:37:10 +08:00
今日活跃度排名 5134
"美国直聘"是什么套路?
职场话题  •  fzinfz  •  2018-03-09 05:46:48 AM  •  最后回复来自 shiyouming91
12
这个是微信小程序 Boolean 数据绑定的 bug 吗?
全球工单系统  •  fzinfz  •  2018-02-04 21:44:50 PM  •  最后回复来自 Zzde
9
Linux kernel Intel driver bug 导致大量笔记本 BIOS 被锁,谁来背锅?
Linux  •  fzinfz  •  2017-12-26 15:30:17 PM  •  最后回复来自 fcten
37
fzinfz 最近回复了
1 天前
回复了 lasuar 创建的主题 Z shell [shell] 关于通配符的两点疑问
"grep -P" 正则表达式
Joplin,除了桌面便签貌似都有: https://joplinapp.org/
缺的功能可以自己补充: https://github.com/laurent22/joplin

Desktop, mobile and terminal applications.
Web Clipper for Firefox and Chrome.
End To End Encryption (E2EE)
Support notes, to-dos, tags and notebooks.
Markdown notes, which are rendered with images and formatting in the desktop and mobile applications. Support for extra features such as math notation and checkboxes.
Search functionality.
貌似没人回,楼主先来第一份回复(对, 我是来给 Python 和 xlwings 打广告的~ 脱离最新技术好久了,欢迎纠错~)

3. What does your app/add-in do?
4. What kind of Office development do you do? (VSTO, macros, etc.)
7. How do you test your app/add-in?

1). load excel data to python pandas dataframes:
a. for simple sheets batch automation, use pandas ( https://pandas.pydata.org/ ) or dask ( https://dask.org/ )
b. for single sheet live analyzing, use xlwings: https://www.xlwings.org/
( This tool can call windows native excel API directly and don't need to install excel plugins. )

2). live analyzing data and write functions on Jupyter notebook( https://jupyter.org/ )

3). present result
a. for simple result, export to excel with xlwings or pandas
b. for complex result, save to db and create a single page site with python flask and jquery datatable
c. if using SQL server, save to db, and refresh data on excel directly

5. Which Office Products have you targeted? (Excel, Outlook, PowerPoint)
Excel

6. Do you use .NET references to Office client libraries for your app/add-in?
Yes, using Microsoft.Office.Interop.Word and Microsoft.Office.Interop.Excel.

8. Do you test on multiple versions of Office and/or Windows? Which versions? 32 bit vs 64 bit?
Yes but don't care.

9. Do the differences in version make a difference when testing? Deploying? How so?
No.

10. How do you deploy your app/add-in today? (Click once, link on website, etc)
link on website

11. What is the most annoying aspects of testing your app/add-in in general?
PivotTable functions are too complex and hard to use: https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel.pivotcache.createpivottable
Seems can't get raw data from PivotCache directly as far as I know.

12. Would a solution like this solve your problem?
No, as I don't use VSTO.

13. Which versions of Windows and Office would you like to see?
Windows 10. Offce 2016+ and 365 online version.

14. We're thinking about pricing the usage of VMs at 1 dollar an hour. How man hours do you regularly test now? How many hours do you think you would use this?
$1/Hour is too expensive for personal use.

15. Have you used Azure before? If so, for what?
No. Azure didn't accept my Chinese credit card.

16. If there was a magic solution for testing the Office apps that would provide the most value to you, what would it be?
Simplify pivot table/chart related functions in Microsoft.Office.Interop.Excel and better provide Python sdk to call them.
Support C# REPL(
) on Azure Notebooks and also for open source Jupyter.
抖屏的时候按按排线(特别驱动板侧)试下。而且貌似高分辨率驱动板兼容问题也多,建议直接成品。
在衣服上贴个"考研专用"的纸条一起拍进去:手动 doge:
15 天前
回复了 yfixx 创建的主题 问与答 租房子出问题了,请教各位 ver 该怎么办?
问下能不能到时见面一起办退租手续,手续办完让他立刻把押金还你。
楼主这水平都被裁,吓得我不敢裸辞了
60 天前
回复了 blackcurrant 创建的主题 硬件 火线零线都有电,电器不工作
市电 36v, 这结果太不正常, 猜测虚接断路,需要万用表测准确电压,优利德最便宜的型号就行可能比你的笔还便宜。另外确认下空开是否带漏保功能。
159 天前
回复了 zhujunhan7 创建的主题 程序员 excel 数据自动填网页
python xlwings(直接调用 windows excel API) + selenium
184 天前
回复了 pinews 创建的主题 奇思妙想 程序中有没有生物父母兄弟姐妹的概念?
面向对象的父类子类是数学上的超类子类,是包含关系。html 类似,不过只有相邻节点算父子算借鉴了生物学吧。个人理解。
关于   ·   FAQ   ·   API   ·   我们的愿景   ·   广告投放   ·   感谢   ·   实用小工具   ·   989 人在线   最高记录 5043   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.3 · 22ms · UTC 22:35 · PVG 06:35 · LAX 14:35 · JFK 17:35
♥ Do have faith in what you're doing.