{"id":52713,"date":"2025-10-20T14:57:05","date_gmt":"2025-10-20T07:57:05","guid":{"rendered":"https:\/\/helpmimosaonline.misa.vn\/?post_type=ht_kb&p=52713"},"modified":"2025-10-20T14:57:40","modified_gmt":"2025-10-20T07:57:40","slug":"dap-ung-xuat-khau-bao-cao-ra-excel-khong-bi-gop-cot-va-khong-lap-lai-tieu-de-cot-khi-bao-cao-co-nhieu-trang","status":"publish","type":"ht_kb","link":"\/ke-toan\/kb\/dap-ung-xuat-khau-bao-cao-ra-excel-khong-bi-gop-cot-va-khong-lap-lai-tieu-de-cot-khi-bao-cao-co-nhieu-trang\/","title":{"rendered":"\u0110\u00e1p \u1ee9ng xu\u1ea5t kh\u1ea9u b\u00e1o c\u00e1o ra excel kh\u00f4ng b\u1ecb g\u1ed9p c\u1ed9t v\u00e0 kh\u00f4ng l\u1eb7p l\u1ea1i ti\u00eau \u0111\u1ec1 c\u1ed9t khi b\u00e1o c\u00e1o c\u00f3 nhi\u1ec1u trang"},"content":{"rendered":"

1. M\u1ee5c \u0111\u00edch<\/h3>\n
\u0110\u00e1p \u1ee9ng cho k\u1ebf to\u00e1n c\u00f3 th\u1ec3 xu\u1ea5t kh\u1ea9u m\u1ed9t s\u1ed1 b\u00e1o c\u00e1o kho ra excel kh\u00f4ng b\u1ecb g\u1ed9p c\u1ed9t v\u00e0 kh\u00f4ng l\u1eb7p l\u1ea1i ti\u00eau \u0111\u1ec1 c\u1ed9t khi b\u00e1o c\u00e1o c\u00f3 nhi\u1ec1u trang \u0111\u1ec3 thu\u1eadn ti\u1ec7n ki\u1ec3m tra d\u1eef li\u1ec7u.<\/p>\n

2. Chi ti\u1ebft thay \u0111\u1ed5i<\/h3>\n
– Tr\u01b0\u1edbc phi\u00ean b\u1ea3n R13:<\/strong> Khi xu\u1ea5t c\u00e1c b\u00e1o c\u00e1o tr\u00ean ra excel, k\u1ebf to\u00e1n ph\u1ea3i t\u1ef1 b\u1ecf d\u00f2ng ti\u00eau \u0111\u1ec1 c\u1ed9t v\u00e0 b\u1ecf g\u1ed9p c\u1ed9t \u0111i \u0111\u1ec3 b\u00e1o c\u00e1o excel l\u00e0 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u li\u00ean t\u1ee5c \u0111\u1ec3 thu\u1eadn ti\u1ec7n l\u1ecdc c\u1ed9t ho\u1eb7c \u0111\u1eb7t c\u00f4ng th\u1ee9c. V\u1edbi b\u00e1o c\u00e1o d\u00e0i do ph\u00e1t sinh r\u1ea5t nhi\u1ec1u v\u1eadt t\u01b0 th\u00ec vi\u1ec7c ch\u1ec9nh s\u1eeda tr\u00ean excel r\u1ea5t m\u1ea5t th\u1eddi gian.<\/p>\n
– K\u1ec3 t\u1eeb phi\u00ean b\u1ea3n R13: <\/strong>Ph\u1ea7n m\u1ec1m \u0111\u00e1p \u1ee9ng xu\u1ea5t excel m\u1ed9t s\u1ed1 b\u00e1o c\u00e1o ra d\u1ea1ng d\u1eef li\u1ec7u (kh\u00f4ng b\u1ecb g\u1ed9p c\u1ed9t v\u00e0 kh\u00f4ng l\u1eb7p l\u1ea1i ti\u00eau \u0111\u1ec1 c\u1ed9t):<\/p>\n
\n
B\u00e1o c\u00e1o quy\u1ebft to\u00e1n t\u1ed5ng h\u1ee3p xu\u1ea5t nh\u1eadp t\u1ed3n<\/li>\n
S22-H: S\u1ed5 chi ti\u1ebft nguy\u00ean li\u1ec7u, v\u1eadt li\u1ec7u, c\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5 v\u00e0 s\u1ea3n ph\u1ea9m h\u00e0ng h\u00f3a<\/li>\n
B\u00e1o c\u00e1o t\u1ed3n kho<\/li>\n<\/ul>\n
C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/em><\/p>\n
\n
V\u00e0o m\u1ee5c B\u00e1o c\u00e1o\\V\u1eadt t\u01b0 h\u00e0ng h\u00f3a.<\/strong><\/li>\n
K\u00edch \u0111\u00fap chu\u1ed9t v\u00e0o b\u00e1o c\u00e1o c\u1ea7n in.<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Khai b\u00e1o tham s\u1ed1 in v\u00e0 nh\u1ea5n Xem b\u00e1o c\u00e1o.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Ch\u1ecdn Xu\u1ea5t Excel d\u1ea1ng d\u1eef li\u1ec7u.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n","protected":false},"excerpt":{"rendered":"
1. M\u1ee5c \u0111\u00edch \u0110\u00e1p \u1ee9ng cho k\u1ebf to\u00e1n c\u00f3 th\u1ec3 xu\u1ea5t kh\u1ea9u m\u1ed9t s\u1ed1 b\u00e1o c\u00e1o kho ra excel kh\u00f4ng b\u1ecb g\u1ed9p c\u1ed9t v\u00e0 kh\u00f4ng l\u1eb7p l\u1ea1i ti\u00eau \u0111\u1ec1 c\u1ed9t khi b\u00e1o c\u00e1o c\u00f3 nhi\u1ec1u trang \u0111\u1ec3 thu\u1eadn ti\u1ec7n ki\u1ec3m tra d\u1eef li\u1ec7u. 2. Chi ti\u1ebft thay \u0111\u1ed5i – Tr\u01b0\u1edbc…<\/p>\n","protected":false},"author":57,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"ht-kb-category":[917],"ht-kb-tag":[],"class_list":["post-52713","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r13"],"_links":{"self":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb\/52713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/users\/57"}],"replies":[{"embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/comments?post=52713"}],"version-history":[{"count":3,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb\/52713\/revisions"}],"predecessor-version":[{"id":52733,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb\/52713\/revisions\/52733"}],"wp:attachment":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/media?parent=52713"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb-category?post=52713"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb-tag?post=52713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}