c#读取数据保存至excel中

Question

callbackdata1303799({"rc":0,"rt":110,"svr":181735295,"lt":2,"full":0,"data":{"tc":63,"qdate":20240313,"pool":[{"c":"002902","m":0,"n":"铭普光磁","p":25860,"zdp":9.995746612548829,"amount":321487440,"ltsz":3896660362.92,"tshare":5493212723.34,"hs":8.250332832336426,"lbc":1,"fbt":92500,"lbt":92500,"fund":333683423,"zbc":0,"hybk":"通信设备","zttj":{"days":1,"ct":1}},{"c":"002873","m":0,"n":"新天药业","p":10550,"zdp":10.010427474975586,"amount":9475229,"ltsz":2364150966.4500005,"tshare":2442474335.25,"hs":0.4007878303527832,"lbc":1,"fbt":92500,"lbt":92500,"fund":140907635,"zbc":0,"hybk":"中药","zttj":{"days":1,"ct":1}},{"c":"605298","m":1,"n":"必得科技","p":12510,"zdp":10.026385307312012,"amount":13775949,"ltsz":1756404000.0,"tshare":1807695000.0,"hs":0.7843269109725952,"lbc":2,"fbt":92503,"lbt":92503,"fund":52431974,"zbc":0,"hybk":"交运设备","zttj":{"days":2,"ct":2}},{"c":"001324","m":0,"n":"长青科技","p":22910,"zdp":9.985597610473633,"amount":65539270,"ltsz":790395000.0,"tshare":3161580000.0,"hs":8.292055130004883,"lbc":2,"fbt":93000,"lbt":93000,"fund":44178086,"zbc":0,"hybk":"交运设备","zttj":{"days":2,"ct":2}},{"c":"002857","m":0,"n":"三晖电气","p":13900,"zdp":9.968354225158692,"amount":46145365,"ltsz":1779200000.0,"tshare":1779200000.0,"hs":2.610546827316284,"lbc":2,"fbt":93000,"lbt":93000,"fund":33208490,"zbc":0,"hybk":"电网设备","zttj":{"days":2,"ct":2}},{"c":"600207","m":1,"n":"安彩高科","p":5710,"zdp":10.019268035888672,"amount":473855568,"ltsz":5998656859.15,"tshare":6219974717.6,"hs":8.008513450622559,"lbc":4,"fbt":93002,"lbt":93729,"fund":90956422,"zbc":1,"hybk":"光伏设备","zttj":{"days":4,"ct":4}},{"c":"600281","m":1,"n":"华阳新材","p":3800,"zdp":10.144927024841309,"amount":51594042,"ltsz":1954727695.0,"tshare":1954727721.6,"hs":2.657593011856079,"lbc":3,"fbt":93012,"lbt":93012,"fund":45740934,"zbc":0,"hybk":"小金属","zttj":{"days":3,"ct":3}},{"c":"300810","m":0,"n":"中科海讯","p":18880,"zdp":20.025428771972658,"amount":206451033,"ltsz":2152269968.0,"tshare":2228784000.0,"hs":9.635334014892579,"lbc":1,"fbt":93015,"lbt":131030,"fund":12530656,"zbc":7,"hybk":"软件开发","zttj":{"days":1,"ct":1}},{"c":"603580","m":1,"n":"艾艾精工","p":13840,"zdp":10.015897750854493,"amount":79424340,"ltsz":1808517088.0,"tshare":1808517088.0,"hs":4.437344551086426,"lbc":4,"fbt":93018,"lbt":93018,"fund":56298241,"zbc":0,"hybk":"塑料制品","zttj":{"days":4,"ct":4}},{"c":"002313","m":0,"n":"日海智能","p":9630,"zdp":10.057143211364746,"amount":287414080,"ltsz":3603960330.7500007,"tshare":3605472000.0000007,"hs":8.006722450256348,"lbc":1,"fbt":93024,"lbt":110230,"fund":28734957,"zbc":2,"hybk":"通信设备","zttj":{"days":12,"ct":6}},{"c":"603803","m":1,"n":"瑞斯康达","p":7250,"zdp":10.015174865722657,"amount":308396368,"ltsz":3080405788.25,"tshare":3156037752.0,"hs":10.115544319152832,"lbc":1,"fbt":93027,"lbt":111100,"fund":24950287,"zbc":4,"hybk":"通信设备","zttj":{"days":1,"ct":1}},{"c":"603261","m":1,"n":"立航科技","p":34440,"zdp":9.996806144714356,"amount":298486880,"ltsz":905678185.4399999,"tshare":2697334669.68,"hs":33.637699127197269,"lbc":4,"fbt":93053,"lbt":95041,"fund":30589608,"zbc":4,"hybk":"航天航空","zttj":{"days":4,"ct":4}},{"c":"001208","m":0,"n":"华菱线缆","p":9240,"zdp":10.0,"amount":176024032,"ltsz":2292192182.28,"tshare":4938077760.0,"hs":7.808164596557617,"lbc":2,"fbt":93103,"lbt":93215,"fund":151388335,"zbc":1,"hybk":"电网设备","zttj":{"days":2,"ct":2}},{"c":"600506","m":1,"n":"统一股份","p":12550,"zdp":9.991235733032227,"amount":263725022,"ltsz":1853721256.15,"tshare":2409837621.7000005,"hs":14.318951606750489,"lbc":1,"fbt":93122,"lbt":103331,"fund":29105960,"zbc":2,"hybk":"石油行业","zttj":{"days":1,"ct":1}},{"c":"000504","m":0,"n":"南华生物","p":8780,"zdp":10.025062561035157,"amount":32151810,"ltsz":2727658024.7799999,"tshare":2897602853.12,"hs":1.187315821647644,"lbc":1,"fbt":93136,"lbt":93136,"fund":31732667,"zbc":0,"hybk":"医疗服务","zttj":{"days":1,"ct":1}},{"c":"002907","m":0,"n":"华森制药","p":14690,"zdp":10.037453651428223,"amount":109444340,"ltsz":4537529537.45,"tshare":6134489940.8,"hs":2.4321391582489015,"lbc":1,"fbt":93306,"lbt":93306,"fund":40835849,"zbc":0,"hybk":"中药","zttj":{"days":1,"ct":1}},{"c":"603051","m":1,"n":"鹿山新材","p":27670,"zdp":10.019880294799805,"amount":101101691,"ltsz":1368581470.47,"tshare":2582140493.1200006,"hs":7.461167335510254,"lbc":1,"fbt":93456,"lbt":93726,"fund":48288134,"zbc":1,"hybk":"塑料制品","zttj":{"days":1,"ct":1}},{"c":"001209","m":0,"n":"洪兴股份","p":17230,"zdp":10.025543212890625,"amount":211834543,"ltsz":694159810.57,"tshare":2266136465.6,"hs":31.880128860473634,"lbc":2,"fbt":93539,"lbt":130103,"fund":37168556,"zbc":2,"hybk":"纺织服装","zttj":{"days":2,"ct":2}},{"c":"003004","m":0,"n":"声迅股份","p":22750,"zdp":10.009671211242676,"amount":66821735,"ltsz":1582837119.5,"tshare":1862059813.25,"hs":4.297760486602783,"lbc":1,"fbt":93706,"lbt":93706,"fund":73257775,"zbc":0,"hybk":"计算机设","zttj":{"days":1,"ct":1}},{"c":"002613","m":0,"n":"北玻股份","p":4090,"zdp":9.946236610412598,"amount":102241592,"ltsz":2470327697.18,"tshare":3833025300.0,"hs":4.178192138671875,"lbc":1,"fbt":93836,"lbt":93836,"fund":23155535,"zbc":0,"hybk":"玻璃玻纤","zttj":{"days":1,"ct":1}}]}});

用C#如何读取这些数组 保存至excel中呢

Answer 1

waslee 下午好🌅🌅🌅
本答案参考ChatGPT-3.5

根据给出的数据，你想要使用C#读取数据并将其保存到Excel中。你可以按照以下步骤来完成这个任务：

1. 解析返回的JSON数据。首先，你需要将从API获取的数据解析为JSON格式，然后提取出你所需要的数据。你可以使用C#中的JSON解析库（如Newtonsoft.Json）来实现这一步骤。以下是使用Newtonsoft.Json库解析数据的示例代码：

using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

string jsonData = "你的JSON数据";
JObject data = JObject.Parse(jsonData);
JObject poolData = (JObject)data["data"]["pool"];
JArray poolArray = (JArray)poolData["pool"];

foreach (JObject item in poolArray)
{
    string stockCode = (string)item["c"];
    string stockName = (string)item["n"];
    decimal stockPrice = (decimal)item["p"];
    // 解析其他数据字段
    // 将数据保存到Excel中
}

1. 将数据保存到Excel中。在上述代码的注释处，你可以使用C#中的Excel操作库（如EPPlus）将解析的数据保存到Excel文件中。以下是使用EPPlus库将数据保存到Excel中的示例代码：

using OfficeOpenXml;

// 创建Excel文件和工作表
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
ExcelPackage excelPackage = new ExcelPackage();
ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("数据");

// 添加表头
worksheet.Cells[1, 1].Value = "股票代码";
worksheet.Cells[1, 2].Value = "股票名称";
worksheet.Cells[1, 3].Value = "股票价格";

// 写入数据
int row = 2;
foreach (JObject item in poolArray)
{
    string stockCode = (string)item["c"];
    string stockName = (string)item["n"];
    decimal stockPrice = (decimal)item["p"];

    worksheet.Cells[row, 1].Value = stockCode;
    worksheet.Cells[row, 2].Value = stockName;
    worksheet.Cells[row, 3].Value = stockPrice;

    row++;
}

// 保存Excel文件
string filePath = "保存路径";
excelPackage.SaveAs(new FileInfo(filePath));

1. 通过以上步骤，你可以成功将数据保存到Excel中。请注意，你需要在项目中添加适当的引用（如Newtonsoft.Json和EPPlus）。

解决方案总结：

1. 使用Newtonsoft.Json库解析返回的JSON数据。
2. 使用EPPlus库将解析的数据保存到Excel中。

修改后的代码如上所示，只需根据具体的情况对代码进行适当的修改，以实现你的需求。