如何在单元格VB.NET上将parms发送到excel writtin函数 [英] How do I send parms to excel writtin function on cell VB.NET

问题描述

我想发送像p1这样的参数，p2



所以如果p =它将打印或写入p2否则删除行



< #if（<＃p1> =;;<＃p2>）>



所有ineed是将值写入已在excel文件中写入的certin函数以生成仅包含值的新文件



excel vb.net



我尝试过：



< #if（<＃p1> =;;< ＃p2>）>

< #if（<＃p1> =;;<＃p2>）>

< #if（ < #p1> =;;< #p2>）>

解决方案

引用：

我想发送像p1，p2

这样的参数，所以如果p =它将打印或写入p2否则删除行

< #if （<＃p1> =;;<＃p2>）>

不清楚您想要做什么。看起来您遇到了问题并需要帮助来应用您设计的解决方案，但您的解决方案可能不是解决方案。请解释一下这个问题，我们可能会找到解决方案。

Quote：

all ineed是为已经在excel文件中写入的certin函数写入值来生成一个只有值的新文件

Excel有一个特殊粘贴函数，只允许你粘贴细胞的价值。该功能在上下文菜单中。



要知道某些操作如何在VBA中翻译，只需告诉Excel记录一个新的宏，做你的东西，然后查看代码产生

iwant to send parms like p1 , p2

so if p="" it will print or write p2 else remove row

<#if(<#p1>="";;<#p2>)>

all ineed is to write value to certin functions already writtin in excel file to genrate a new file with only values

excel vb.net

What I have tried:

<#if(<#p1>="";;<#p2>)>
<#if(<#p1>="";;<#p2>)>
<#if(<#p1>="";;<#p2>)>

解决方案

Quote:

iwant to send parms like p1 , p2
so if p="" it will print or write p2 else remove row
<#if(<#p1>="";;<#p2>)>

Not clear what you want to do. Looks like you have a problem and want help to apply the solution you devised, but it is possible that your solution is not the solution. Please explain the problem and we might find the solution.

Quote:

all ineed is to write value to certin functions already writtin in excel file to genrate a new file with only values

Excel have a Special Paste function that allow you to paste only values of cells. The function is in contextual menu.

To know how some operation translate in VBA, just tell Excel to record a new macro, do your stuff and then look at the code generated.

这篇关于如何在单元格VB.NET上将parms发送到excel writtin函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！