VB和Excel [英] VB and Excel

问题描述

大家好

关于这个问题，我只是在问是否可能.

With this question, I am just asking if its possible or not.

我有两个按钮(Button1，Button2)的VB应用程序.

I have VB application with two buttons , Button1, Button2.

我希望在将button1按下时，将它写在excel工作表中(与button2类似)，并触发事件的日期和时间.

I want that when button1 is pressed, is written in the excel sheet, similarly for the button2, with the date and time of event triggered.

我知道我们可以使用Stream.Write来追加文本等.但是到目前为止，我所面临的挑战是如何处理excel工作表中的列?我的意思是我们如何将输出定向到特定的列等.Excel工作表如下所示:

I know that we can use Stream.Write to append the text etc. but the challenge I see so far is how to cope with the columns in excel sheet? I mean how we can direct output to specific column etc. Excel sheet looks like following:

预先感谢.

推荐答案

如果您在此论坛上浏览一下，您会发现Karen在VB上发表了一篇文章.和Excel，

If you look down in this forum, you will recognizse that Karen has made an article about VB and Excel,

也许可以读懂.

这篇关于VB和Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！