{"id":45313,"date":"2023-11-14T22:16:54","date_gmt":"2023-04-22T09:59:50","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/"},"modified":"2024-05-04T09:03:43","modified_gmt":"2024-05-04T01:03:43","slug":"45313-2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/","title":{"rendered":""},"content":{"rendered":"

\u30d5\u30ea\u30fc\u30e9\u30f3\u30b9\u30a8\u30f3\u30b8\u30cb\u30a2\u3068\u3057\u3066\u6d3b\u52d5\u3057\u3066\u3044\u3066\u3001\u73fe\u5728\u643a\u308f\u3063\u3066\u3044\u308b\u6848\u4ef6\u3067\u306fRust\u3068Tauri\u3092\u4f7f\u3063\u3066Excel\u30d5\u30a1\u30a4\u30eb\u3092\u51fa\u529b\u3059\u308b\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u30a2\u30d7\u30ea\u3092\u958b\u767a\u3057\u3066\u3044\u307e\u3059\u3002\u5148\u65e5\u3001\u9867\u5ba2\u304b\u3089\u51fa\u529b\u3059\u308bExcel\u30d5\u30a1\u30a4\u30eb\u3067\u91d1\u984d\u306f\u9593\u9055\u3044\u3092\u9632\u6b62\u3059\u308b\u305f\u3081\u306b\u30ab\u30f3\u30de\u533a\u5207\u308a\u306b\u3057\u305f\u3044\u3068\u3044\u3046\u8981\u671b\u304c\u3042\u308a\u307e\u3057\u305f\u306e\u3067\u3001Rust\u3067\u30bb\u30eb\u306e\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b\u65b9\u6cd5\u3092\u8abf\u3079\u307e\u3057\u305f\u3002<\/p>\n

\u524d\u56de\u306e\u8a18\u4e8b\u304b\u3089\u5f15\u304d\u7d9a\u304d\u3001\u4eca\u56de\u3082Excel\u30d5\u30a1\u30a4\u30eb\u3092\u66f8\u304d\u8fbc\u3080\u305f\u3081\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u3068\u3057\u3066\u300cxlsxwriter-rs\u300d\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n

xlsxwriter-rs\u3067\u30bb\u30eb\u306e\u66f8\u5f0f\u8a2d\u5b9a\u3092\u884c\u3046\u306b\u306fwrite_number_with_format\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u7b2c\u4e00\u5f15\u6570\u306b\u884c\u756a\u53f7\u3001\u7b2c\u4e8c\u5f15\u6570\u306b\u306f\u5217\u756a\u53f7\u3001\u7b2c\u4e09\u5f15\u6570\u306b\u306f\u5024\u3001\u7b2c\u56db\u5f15\u6570\u306b\u306f\u66f8\u5f0f\u306e\u69cb\u9020\u4f53\u306e\u3092\u6e21\u3057\u307e\u3059\u3002<\/p>\n

pub fn write_number_with_format<T>(\r\n    &mut self,\r\n    row: RowNum,\r\n    col: ColNum,\r\n    number: T,\r\n    format: &Format\r\n) -> Result<&mut Worksheet, XlsxError>\r\nwhere\r\n    T: Into<f64>,\r\n<\/code><\/pre>\n
Write a formatted number to a worksheet cell.
\nWrite a number with formatting to a worksheet cell. The format is set via a Format struct which can control the numerical formatting of the number, for example as a currency or a percentage value, or the visual format, such as bold and italic text.
\nAll numerical values in Excel are stored as IEEE 754 Doubles which are the equivalent of rust\u2019s f64 type. This method will accept any rust type that will convert Into a f64. These include i8, u8, i16, u16, i32, u32 and f32 but not i64 or u64. IEEE 754 Doubles and f64 have around 15 digits of precision. Anything beyond that cannot be stored by Excel as a number without loss of precision and may need to be stored as a string instead.
\nExcel doesn\u2019t have handling for NaN or INF floating point numbers. These will be stored as the strings \u201cNan\u201d, \u201cINF\u201d, and \u201c-INF\u201d strings instead.<\/p>\n
Arguments
\nrow – The zero indexed row number.
\ncol – The zero indexed column number.
\nnumber – The number to write to the cell.
\nformat – The Format property for the cell.<\/p><\/blockquote>\n
 <\/p>\n
\u7b2c\u56db\u5f15\u6570\u306b\u306f\u66f8\u5f0f\u306e\u69cb\u9020\u4f53\u306fFormat\u69cb\u9020\u4f53\u306eset_num_format\u30e1\u30bd\u30c3\u30c9\u3067\u751f\u6210\u3057\u307e\u3059\u3002write_number_with_format\u30e1\u30bd\u30c3\u30c9\u3068Format\u69cb\u9020\u4f53\u306eset_num_format\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u6570\u5024\u3092\u30ab\u30f3\u30de\u533a\u5207\u308a\u306b\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u3092\u8f09\u305b\u307e\u3059\u3002<\/p>\n
use<\/span> std<\/span>::<\/span>path<\/span>::<\/span>Path<\/span>;<\/span>\r\nuse<\/span> rust_xlsxwriter<\/span>::<\/span>Workbook<\/span>;<\/span>\r\n\r\nlet<\/span> mut<\/span> book<\/span> =<\/span> Workbook<\/span>::<\/span>new<\/span>();<\/span>\r\nlet<\/span> comma_format<\/span>=<\/span> Format<\/span>::<\/span>new<\/span>()<\/span>.set_num_format<\/span>(<\/span>\"#,##0\"<\/span>);<\/span>\r\n\r\nlet<\/span> sheet<\/span> =<\/span> book<\/span>.add_worksheet<\/span>();<\/span>\r\nsheet<\/span>.set_freeze_panes<\/span>(<\/span>1<\/span>,<\/span> 1<\/span>)<\/span>?<\/span>;<\/span>\r\nsheet<\/span>.write_string<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> \"Header1\"<\/span>)<\/span>?<\/span>;<\/span>\r\nsheet<\/span>.write_string<\/span>(<\/span>0<\/span>,<\/span> 1<\/span>,<\/span> \"Header2\"<\/span>)<\/span>?<\/span>;<\/span>\r\nfor<\/span> i<\/span> in<\/span> 1<\/span>..<\/span>101<\/span> {<\/span>\r\n    sheet<\/span>.write_number<\/span>(<\/span>i<\/span> as<\/span> u32<\/span>,<\/span> 0<\/span>,<\/span> i<\/span> as<\/span> f64<\/span>)<\/span>?<\/span>;<\/span>\r\n    sheet<\/span>.write_number_with_format<\/span>(<\/span>i<\/span> as<\/span> u32<\/span>,<\/span> 1<\/span>,<\/span> (<\/span>i<\/span> *<\/span> 10000<\/span>)<\/span> as<\/span> f64<\/span>,<\/span> &<\/span>comma_format<\/span>)<\/span>?<\/span>;<\/span>\r\n}<\/span>\r\nbook<\/span>.save<\/span>(<\/span>Path<\/span>::<\/span>new<\/span>(<\/span>\"test.xlsx\"<\/span>))<\/span>?<\/span>;<\/span>\r\n<\/code><\/pre>\n
\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8<\/div>\n
\u7121\u4e8bRust\u3067\u3082Excel\u306e\u30bb\u30eb\u306e\u66f8\u5f0f\u306e\u8a2d\u5b9a\u304c\u5b9f\u73fe\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n
\u66f8\u5f0f\u306e\u90e8\u5206\uff08#,##0\uff09\u3092\u5909\u66f4\u3057\u305f\u3089\uff05\u8868\u793a\u306b\u3057\u305f\u308a\u3001\u5c0f\u6570\u70b9\u4ee5\u4e0b\u306e\u66f8\u5f0f\u3082\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002\u307e\u305f\u3001\u592a\u5b57\u306b\u3057\u305f\u308a\u659c\u4f53\u306b\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n
let<\/span> currency_format<\/span> =<\/span> Format<\/span>::<\/span>new<\/span>()<\/span>.set_num_format<\/span>(<\/span>\"\u20ac#,##0.00\"<\/span>);<\/span>\r\nsheet<\/span>.write_number_with_format<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 1234.5<\/span>,<\/span> &<\/span>currency_format<\/span>)<\/span>?<\/span>;<\/span>\r\n\r\nlet<\/span> percentage_format<\/span> =<\/span> Format<\/span>::<\/span>new<\/span>()<\/span>.set_num_format<\/span>(<\/span>\"0.0%\"<\/span>);<\/span>\r\nsheet<\/span>.write_number_with_format<\/span>(<\/span>1<\/span>,<\/span> 0<\/span>,<\/span> 0.3300<\/span>,<\/span> &<\/span>percentage_format<\/span>)<\/span>?<\/span>;<\/span>\r\n\r\nlet<\/span> bold_italic_format<\/span> =<\/span> Format<\/span>::<\/span>new<\/span>()<\/span>.set_bold<\/span>()<\/span>.set_italic<\/span>();<\/span>\r\nsheet<\/span>.write_number_with_format<\/span>(<\/span>2<\/span>,<\/span> 0<\/span>,<\/span> 1234.5<\/span>,<\/span> &<\/span>bold_italic_format<\/span>)<\/span>?<\/span>;<\/span>\r\n<\/code><\/pre>\n
\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8<\/div>\n
\u4e0a\u8a18\u4ee5\u5916\u306b\u3082\u3044\u308d\u3044\u308d\u306a\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u3067\u3061\u3087\u3063\u3068\u8a66\u3057\u3066\u307f\u3066\u306f\u3044\u304b\u304c\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u30d5\u30ea\u30fc\u30e9\u30f3\u30b9\u30a8\u30f3\u30b8\u30cb\u30a2\u3068\u3057\u3066\u6d3b\u52d5\u3057\u3066\u3044\u3066\u3001\u73fe\u5728\u643a\u308f\u3063\u3066\u3044\u308b\u6848\u4ef6\u3067\u306fRust\u3068Tauri\u3092\u4f7f\u3063\u3066Excel\u30d5\u30a1\u30a4 […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-45313","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n- Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:description\" content=\"\u30d5\u30ea\u30fc\u30e9\u30f3\u30b9\u30a8\u30f3\u30b8\u30cb\u30a2\u3068\u3057\u3066\u6d3b\u52d5\u3057\u3066\u3044\u3066\u3001\u73fe\u5728\u643a\u308f\u3063\u3066\u3044\u308b\u6848\u4ef6\u3067\u306fRust\u3068Tauri\u3092\u4f7f\u3063\u3066Excel\u30d5\u30a1\u30a4 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-22T09:59:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T01:03:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d5e2237434c4406cf44f1\/8-0.png\" \/>\n<meta name=\"author\" content=\"\u6587, \u7fd4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6587, \u7fd4\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/\",\"name\":\"- Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-22T09:59:50+00:00\",\"dateModified\":\"2024-05-04T01:03:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\",\"name\":\"\u6587, \u7fd4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"caption\":\"\u6587, \u7fd4\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"- Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/","og_locale":"zh_CN","og_type":"article","og_description":"\u30d5\u30ea\u30fc\u30e9\u30f3\u30b9\u30a8\u30f3\u30b8\u30cb\u30a2\u3068\u3057\u3066\u6d3b\u52d5\u3057\u3066\u3044\u3066\u3001\u73fe\u5728\u643a\u308f\u3063\u3066\u3044\u308b\u6848\u4ef6\u3067\u306fRust\u3068Tauri\u3092\u4f7f\u3063\u3066Excel\u30d5\u30a1\u30a4 […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-22T09:59:50+00:00","article_modified_time":"2024-05-04T01:03:43+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d5e2237434c4406cf44f1\/8-0.png"}],"author":"\u6587, \u7fd4","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6587, \u7fd4","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/","name":"- Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-22T09:59:50+00:00","dateModified":"2024-05-04T01:03:43+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c","name":"\u6587, \u7fd4","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","caption":"\u6587, \u7fd4"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/45313-2\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/45313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=45313"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/45313\/revisions"}],"predecessor-version":[{"id":97393,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/45313\/revisions\/97393"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=45313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=45313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=45313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}