帮助循环构造发送到excel单元格 [英] Help with a loop construction to send to excel cells
问题描述
所以,这是一个问题:
我是visual basic的新手,我需要创建一个循环来填充excel上的列,并使用我计算的变量例如:
i'm new on visual basic, and i need to make a loop to fill a column on excel with variables that i calculate ex:
我有一个总时间(t)
我的时间间隔是总时间的1/10(dt)
and i have a time interval that is 1/10 of the total time (dt)
我希望从C2 =第一时间间隔开始直到达到总时间,但是,总时间和时间间隔有时不是整数值,一个选项是使计数n为整数,n =总时间(t)/时间间隔(dt)
and i want that starting from C2 = first time interval until reachs the total time, but, the total time and the time interval wasn't sometimes integer values, one option is to make the count doing n as integer, n = totaltime(t)/time interval(dt)
,但是,我如何进行循环并在sime时间发送excel单元格?
, but, how i do the loop and send at the sime time for the excel cells?
推荐答案
您好,
在任何人可以协助之前你需要指明
Before anyone can assist you need to indicate
- 什么类型的excel文件.xls,.xlsx或者两者兼而有?
- 你使用的是Excel自动化,第三派对图书馆?
- 不确定"sime"是什么意思时间(相同?)?
关于项目符号2,如果你没有选择方法,考虑查看SpreadSheetLight(免费的Excel库),我有
此处
代码示例(但这不是解决方案,而是使用Excel的方法)
In regards to bullet two, if you have not selected a method, consider looking at SpreadSheetLight (free Excel library), I have code samples here (but this is not a solution but instead a method to work with Excel)
老实说,你的描述部分但完全清楚你所追求的是什么,所以请花点时间解释一下。
Honestly your description is partly but fully clear in what you are after so please take your time explaining things.
这篇关于帮助循环构造发送到excel单元格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!