Excel XLL编写技术(用于开发UDF和土木工程目的) [英] Technology for Writing Excel XLL(for developeing UDF's for Civil Engineering Purposes)

查看:271
本文介绍了Excel XLL编写技术(用于开发UDF和土木工程目的)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述





亲爱的所有人,


首先让我自我介绍一下。基本上我是经典C的土木结构工程师,并且学习了VBA(主要是Excel)用于开发内部Excel
Spread Sheet(UDF和Macros用于自动化我们的办公室工作。


  1. 我想知道开发EXCEL XLL文件的最佳方法或技术是什么开发UDF和分发。任何简单的样本文件都非常有用。
  2. 我也是想要使用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


如何使用脚本控件调用函数


问候,


Celeste


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.

  1. 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.
  2. 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,

Celeste


这篇关于Excel XLL编写技术(用于开发UDF和土木工程目的)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆