将电子表格值转换为C＃中的格式文本(Convert Spreadsheet values to Formated Text in C#)

 我在电子表格中有一些值，如下例所示： 
 
 
 我总是至少有2列（可能很多），并且值之间总是有空行。 
 
 我想做的事情：复制这两列，粘贴在一个textBox中，当我按下一个按钮时，我希望这个文本的格式如下： 
 
 
 所以，基本上我需要： 
 
 
 
 删除空行 
 
 
 两列中的每个值都需要在单引号之间 
 
 
 来自同一行（A1和B1）的值之间必须有逗号 
 
 
 每行必须以“[”开头，以“]结束，” 
 
 
 最后一行不得有结尾逗号。 
 
 
 是的，我需要的是将excel表转换为Java Script矩阵，以便在Selenium Web浏览器自动化上使用。 
 
 我已经做了一个帮助我很多的代码，但只是在excel中使用一个列，将其转换为一个简单的javascript向量，这里是代码： 
 
String[] vector = textBox1.Text.Split(new String[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
String vectorFinal = String.Join("','", vector);
textBox2.Text = "'" + vectorFinal + "'";
Clipboard.SetText(textBox2.Text);
 
 我刚刚开始研究C＃，这就是为什么我仍然不知道如何去做。 处理多个列涉及TAB字符，这让我疯狂哈哈...提前感谢！ 

I have some values in a spreadsheet like this example:
 
 
I always have at least 2 columns (could be a lot) and also there are always empty lines between the values.
 
What I want to do: copy these 2 columns, paste in a textBox and when I press a button, I'd like to have this text formatted like this:
 
 
So, basically I need:
 
 
 
Remove empty lines
 
 
Each value from both columns needs to be between single quotes
 
 
The values from the same line (A1 and B1) must have a comma between them
 
 
Each line must start with "[" and end with "],"
 
 
The last line must not have the ending comma.
 
 
Yes, what I need is to convert a excel table to a Java Script matrix, to use on Selenium web browser automation.
 
I already did one code that's helping me a lot, but just with a single column in excel, to convert it to a simple javascript vector, here's the code:
 
String[] vector = textBox1.Text.Split(new String[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
String vectorFinal = String.Join("','", vector);
textBox2.Text = "'" + vectorFinal + "'";
Clipboard.SetText(textBox2.Text);
 
I'm just starting to study C#, that's why I still have no idea how to do it. Dealing with multiple columns involve TAB characters that are driving me crazy haha ... thanks in advance!

原文：https://stackoverflow.com/questions/28802241