我正在研究一个商业应用软件,该应用软件将根据上市公司的财务报表进行财务计算。具体地说,我想使用以下网页的数据,例如 this 。例如第一栏的营业收入数字。
我目前的计划是将页面分析为 htm 文件( 如果可以的话 ) 。 但是这是我第一次尝试写入一个与网络互动的应用程序, 所以我不确定这是不是最好的操作方式。 我目前期待执行 < a href=> http:// htmlaglitypack.codeplex. com/" rel="nofollow" 标题 = "TXN" >This 库。 来进行解析 。
一旦我掌握了所有相关的数字并做了计算,我想将结果放入Excel电子表格中,这也是我不懂的。
任何详细介绍如何执行本计划或如何形成更好的计划的建议或答复,都十分感谢。
对于公开交易公司的财务数据,您可能想要使用网络服务,而不是分析 HTML 。 < a href="https://data.nasdaq.com/xml.aspx" rel="nofollow" > this 是这种网络服务的一个例子(虽然我不因其价格或可靠性而担保-我从未使用过它)。 您可以在视觉工作室创建一个简单的控制台应用程序( VSTO 解决方案可能更好, 我只是没有多少使用它的经验), 通过网络服务检索数据, 然后通过 < a href=" http://msdn.microsoft.com/en-us/library/microft.office.interop.exop.excel%28v=office.14%29.aspx” rel=“nofol” >Excel Interop 。关于SO 和所有网络上的Excel interop的许多文章。
你试图做什么 听起来如此常见, 所以我想知道,是否有 现有的报告套件 在哪里可以提供。
For an Excel formula I need the first cell out of a list of cells which contains a numeric value: A | B | C | ... | Z | ----------------------------- | 0.1 | 0.4 | ... | =0.1 | | ...
I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I m using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the ...
Does anyone know how to convert an Excel date to a correct Unix timestamp?
I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...
I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...
I have created an Add-In in C# that implements user defined functions for Excel. These UDF s return immediately, but they control background asynchronous procedures. These procedures have status ...
