Excel XLL编写技术(用于开发UDF和土木工程目的) [英] Technology for Writing Excel XLL(for developeing UDF's for Civil Engineering Purposes)
问题描述
亲爱的所有人,
首先让我自我介绍一下。基本上我是经典C的土木结构工程师,并且学习了VBA(主要是Excel)用于开发内部Excel
Spread Sheet(UDF和Macros用于自动化我们的办公室工作。
- 我想知道开发EXCEL XLL文件的最佳方法或技术是什么开发UDF和分发。任何简单的样本文件都非常有用。
- 我也是想要使用JavaScript和HTML在EXCEL中以VBA形式呈现输出。
愿意学习任何编程语言。
编程技术已知:C,VBA,HTML,JavaScript,JQuery。
对上述任何建议或帮助表示高度赞赏。
问候,
Mallikarjun
您好,
要开发Excel XLL,请访问欢迎使用Excel软件开发工具包
您可以从 https下载SDK ://www.microsoft.com/en-us/download/details.aspx?id = 35567 它包含概念概述,编程任务和示例项目
,以指导您开发Excel 2013 XLLs。
要在VBA中调用js函数,请访问类似的主题和KB:
https://stackoverflow.com/questions/23580472/calling-javascript-files-from-vba
问候,
Dear All,
First of allow me introduce myself. Basically I am Civil Structural engineer good in Classic C and learnt VBA (mainly Excel) for developing in house Excel Spread Sheet (both UDF’s and Macros for automating our office works.
- I want know what is the best method or technology to develop EXCEL XLL files for developing UDF’s and for distribution. Any simple sample file would be very useful.
- Also I want to make use of JavaScript and HTML for presenting the outputs in VBA forms from within EXCEL.
Willing to learn any programming language.
Programming Technologies known: C, VBA, HTML, JavaScript, JQuery.
Any suggestion or help regarding above said is highly appreciated.
Regards,
Mallikarjun
Hello,
To develop Excel XLL, please visit Welcome to the Excel Software Development Kit
You could download the SDK from https://www.microsoft.com/en-us/download/details.aspx?id=35567 It contains conceptual overviews, programming tasks, and sample projects to guide you in developing Excel 2013 XLLs.
To call js function in the VBA, please visit the similar thread and the KB:
https://stackoverflow.com/questions/23580472/calling-javascript-files-from-vba
How To Call Functions Using the Script Control
Regards,
这篇关于Excel XLL编写技术(用于开发UDF和土木工程目的)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!