c#/vb.net 读取 excel 中的表单控件-k8凯发天生赢家

pm> install-package spire.xls

using system;
using spire.xls;
using spire.xls.core;
namespace getformcontrol
{
    class program
    {
        static void main(string[] args)
        {
            //创建workbook类的实例，加载excel文档
            workbook wb = new workbook();
            wb.loadfromfile("sample.xlsx");
            //获取第1张工作表
            worksheet sheet = wb.worksheets[0];
            //获取textbox
            itextbox textbox = sheet.textboxes[0];          
            string textcontent = textbox.text;
            console.writeline("textbox: "  textcontent);
            console.readline();
            //获取radio button
            for (int i = 0; i < sheet.radiobuttons.count; i  )
            {
                iradiobutton radiobutton = sheet.radiobuttons[i];
                string name = radiobutton.checkstate.tostring();
                string text = radiobutton.text;
                bool islocked = radiobutton.islocked;
                console.writeline("radiobuttons: "   name   text   " 是否锁定："   islocked.tostring());
                console.readline();
            }
            //获取combo box控件中的选中的值（注：非列表中所有选项值）            
            string value = sheet.comboboxes[0].selectedvalue;
            console.writeline("comboboxes: "   value);
            console.readline();                       
            //获取checkbox
            for (int z = 0; z < sheet.checkboxes.count; z  )
            {
                icheckbox checkbox = sheet.checkboxes[z];
                string text = checkbox.text;
                string name = checkbox.checkstate.tostring();
                string alternativetext = checkbox.alternativetext;
                console.writeline("checkboxes: "   text   name   alternativetext);
                console.readline();
            }
            //获取spinnershape
            for (int j = 0; j < sheet.spinnershapes.count; j  )
            {
                ispinnershape spinnershape = sheet.spinnershapes[j];
                string rangeaddress = spinnershape.linkedcell.rangeaddress;
                int currentvalue = spinnershape.currentvalue;
                console.writeline("spinnershapes: rangeaddress is "   rangeaddress   "\n" "currentvalue:"   currentvalue);
                console.readline();               
            }
        }
    }
}

imports spire.xls
imports spire.xls.core
namespace getformcontrol
	class program
		private shared sub main(args as string())
			'创建workbook类的实例，加载excel文档
			dim wb as new workbook()
			wb.loadfromfile("sample.xlsx")
			'获取第1张工作表
			dim sheet as worksheet = wb.worksheets(0)
			'获取textbox
			dim textbox as itextbox = sheet.textboxes(0)
			dim textcontent as string = textbox.text
			console.writeline(convert.tostring("textbox: ") & textcontent)
			console.readline()
			'获取radio button
			for i as integer = 0 to sheet.radiobuttons.count - 1
				dim radiobutton as iradiobutton = sheet.radiobuttons(i)
				dim name as string = radiobutton.checkstate.tostring()
				dim text as string = radiobutton.text
				dim islocked as boolean = radiobutton.islocked
				console.writeline((convert.tostring(convert.tostring("radiobuttons: ") & name) & text)   " 是否锁定："   islocked.tostring())
				console.readline()
			next
			'获取combo box控件中的选中的值（注：非列表中所有选项值）            
			dim value as string = sheet.comboboxes(0).selectedvalue
			console.writeline(convert.tostring("comboboxes: ") & value)
			console.readline()
			'获取checkbox
			for z as integer = 0 to sheet.checkboxes.count - 1
				dim checkbox as icheckbox = sheet.checkboxes(z)
				dim text as string = checkbox.text
				dim name as string = checkbox.checkstate.tostring()
				dim alternativetext as string = checkbox.alternativetext
				console.writeline(convert.tostring(convert.tostring(convert.tostring("checkboxes: ") & text) & name) & alternativetext)
				console.readline()
			next
			'获取spinnershape
			for j as integer = 0 to sheet.spinnershapes.count - 1
				dim spinnershape as ispinnershape = sheet.spinnershapes(j)
				dim rangeaddress as string = spinnershape.linkedcell.rangeaddress
				dim currentvalue as integer = spinnershape.currentvalue
				console.writeline((convert.tostring("spinnershapes: rangeaddress is ") & rangeaddress)   vblf   "currentvalue:"   currentvalue)
				console.readline()
			next
		end sub
	end class
end namespace