{"id":3330,"date":"2017-08-21T15:45:04","date_gmt":"2017-08-21T15:45:04","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-configurer-des-requetes-web-netsuite-dans-excel-pour-la-creation-de-rapports\/"},"modified":"2026-07-28T18:25:41","modified_gmt":"2026-07-28T18:25:41","slug":"comment-configurer-des-requetes-web-netsuite-dans-excel-pour-la-creation-de-rapports","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-configurer-des-requetes-web-netsuite-dans-excel-pour-la-creation-de-rapports\/","title":{"rendered":"Comment configurer des requ\u00eates Web NetSuite dans Excel pour la cr\u00e9ation de rapports"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"D\u00e9couvrez comment configurer les donn\u00e9es des rapports NetSuite pour des requ\u00eates Web directes dans Microsoft Excel, en tenant compte des restrictions sp\u00e9cifiques \u00e0 chaque type de rapport.","ga_short_answer":"NetSuite permet d\u2019interroger certains rapports, tels que les rapports de ventes, directement depuis Excel \u00e0 l\u2019aide de la fonctionnalit\u00e9 Web Query. Bien que certains rapports financiers, comme le compte de r\u00e9sultat, ne prennent pas en charge cette fonctionnalit\u00e9, la proc\u00e9dure est simple pour les rapports compatibles. Il vous suffit de saisir vos identifiants de connexion NetSuite lorsque vous y \u00eates invit\u00e9 \u00e0 l\u2019ouverture du fichier Excel afin d\u2019actualiser les donn\u00e9es.","ga_scenario":"Les utilisateurs cherchent souvent \u00e0 <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/demystifying-odbc-and-netsuites-suiteanalytics-connect-for-data-access\/\">int\u00e9grer directement les donn\u00e9es des rapports NetSuite dans Microsoft Excel<\/a> afin de proc\u00e9der \u00e0 des analyses plus approfondies et \u00e0 des mises \u00e0 jour dynamiques. La difficult\u00e9 r\u00e9side dans l\u2019identification des rapports NetSuite compatibles avec la fonctionnalit\u00e9 \u00ab Web Query \u00bb d\u2019Excel et dans la d\u00e9termination des \u00e9tapes n\u00e9cessaires pour \u00e9tablir cette connexion.","ga_solution":"La possibilit\u00e9 d\u2019utiliser la fonctionnalit\u00e9 Web Query dans Excel pour extraire des donn\u00e9es des rapports NetSuite varie selon le type de rapport. Il a \u00e9t\u00e9 constat\u00e9 que certains rapports financiers, tels que le compte de r\u00e9sultat (P&L), peuvent ne pas prendre en charge cette fonctionnalit\u00e9. En revanche, d\u2019autres cat\u00e9gories de rapports, comme les rapports de ventes, sont g\u00e9n\u00e9ralement compatibles.Pour extraire correctement des donn\u00e9es d\u2019un rapport NetSuite compatible \u00e0 l\u2019aide d\u2019une requ\u00eate Web dans Excel :\n1. Ouvrez le fichier Excel contenant la requ\u00eate Web.\n2. Lorsque vous y \u00eates invit\u00e9, saisissez vos identifiants de connexion NetSuite. Cette \u00e9tape d\u2019authentification est essentielle pour que le fichier Excel puisse se connecter \u00e0 NetSuite et actualiser les donn\u00e9es du rapport.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:45:04-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Web Query on Excel files, how to set it up","ga_ans_id":"ANS-1591","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Web Services & Integrations","footnotes":""},"ga_category":[102,28,102],"ga_audience":[89],"ga_difficulty":[93],"class_list":["post-3330","qa_entry","type-qa_entry","status-publish","hentry","ga_category-services-web-et-integrations","ga_category-web-services-integrations","ga_audience-administrateur-netsuite","ga_difficulty-debutant"],"taxonomy_info":{"ga_category":[{"value":102,"label":"Services Web et int\u00e9grations"},{"value":28,"label":"Web Services & Integrations"},{"value":102,"label":"Services Web et int\u00e9grations"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":93,"label":"D\u00e9butant"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3330\/revisions"}],"predecessor-version":[{"id":5250,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3330\/revisions\/5250"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3330"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3330"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3330"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}