{"id":654,"date":"2024-04-17T21:08:19","date_gmt":"2024-04-17T21:08:19","guid":{"rendered":"https:\/\/www.bleuio.com\/blog\/?p=654"},"modified":"2024-09-19T15:51:50","modified_gmt":"2024-09-19T15:51:50","slug":"reading-data-from-ble-device-using-microsoft-excel-and-bleuio","status":"publish","type":"post","link":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/","title":{"rendered":"Reading data from BLE device using Python, Microsoft Excel and BleuIO"},"content":{"rendered":"\n<p>In today&#8217;s data-driven world, extracting meaningful insights from raw data is crucial for informed decision-making. <strong>Microsoft Excel<\/strong> stands as an amazing tool for data analysis, offering powerful features for visualization, manipulation, and interpretation. However, accessing and processing data from external sources, such as BLE devices, can often be challenging and time-consuming.<\/p>\n\n\n\n<p>BleuIO revolutionizes <strong><a href=\"https:\/\/www.bleuio.com\/\">BLE application development<\/a><\/strong> with its intuitive AT command interface, eliminating the need for complex coding. With BleuIO, developers can communicate effortlessly with BLE devices, retrieve data, and execute commands with ease. Whether you&#8217;re a seasoned developer or just starting out, BleuIO streamlines the development process, allowing you to focus on innovation rather than technical complications. In this tutorial we will see how to read data from an air quality monitoring BLE device and get it on Microsoft excel sheet for further analysis. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What is BleuIO?<\/h3>\n\n\n\n<p>BleuIO is a versatile BLE 5.0 USB dongle designed to simplify the development of BLE applications. With its AT command interface, developers can easily communicate with BLE devices without the need for complex coding. Whether you&#8217;re a beginner or an experienced developer, BleuIO makes BLE application development faster and more accessible.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Setting Up the Environment<\/h3>\n\n\n\n<p>Before we dive into the code, let&#8217;s set up our development environment. You&#8217;ll need:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.bleuio.com\/\">BleuIO USB dongle<\/a><\/li>\n\n\n\n<li>Microsoft Excel<\/li>\n\n\n\n<li>Python installed on your system<\/li>\n\n\n\n<li><a href=\"https:\/\/www.hibouair.com\/\">HibouAir &#8211; air quality monitoring device<\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Communicating with BleuIO<\/h3>\n\n\n\n<p>To communicate with BleuIO, we&#8217;ll use <strong>Python <\/strong>and its <code>serial<\/code> library. First, ensure that you have the <code>pyserial<\/code> library installed. Then, connect BleuIO to your computer and identify the serial port it&#8217;s connected to. Next, we&#8217;ll send AT commands to BleuIO and retrieve the responses.<\/p>\n\n\n\n<p>Here is the complete python code <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import serial\nimport re\nimport json\n\n# Define the serial port and baudrate\nserial_port = \"COM8\"\nbaudrate = 57600\n\n\ndef read_response(ser):\n    \"\"\"\n    Read response from serial port until a newline character is encountered.\n    \"\"\"\n    response = b\"\"\n    while True:\n        char = ser.read(1)\n        if char == b\"\":\n            break  # No more data to read\n        response += char\n        if char == b\"\\n\\n\":\n            break  # Reached end of response\n    return response.decode()\n\n\ndef hex_to_decimal(hex_str):\n    \"\"\"\n    Convert hexadecimal string to decimal integer.\n    \"\"\"\n    return round(int(hex_str, 16) \/ 10.0, 1)\n\n\ndef find_pattern(response):\n    \"\"\"\n    Find and extract patterns matching the specified format.\n    \"\"\"\n    pattern = r\"\\{T:\\\"(\\w+)\\\",H:\\\"(\\w+)\\\",PM1:\\\"(\\w+)\\\"PM2\\.5:\\\"(\\w+)\\\"PM10:\\\"(\\w+)\\\",IAQ:\\\"(\\w+)\\\",PPM:\\\"(\\w+)\\\"\\}\"\n    matches = re.findall(pattern, response)\n    return &#91;\n        {\n            \"T\": hex_to_decimal(m&#91;0]),\n            \"H\": hex_to_decimal(m&#91;1]),\n            \"PM1\": hex_to_decimal(m&#91;2]),\n            \"PM2.5\": hex_to_decimal(m&#91;3]),\n            \"PM10\": hex_to_decimal(m&#91;4]),\n            # \"IAQ\": hex_to_decimal(m&#91;5]),\n            # \"PPM\": hex_to_decimal(m&#91;6]),\n        }\n        for m in matches\n    ]\n\n\ndef main():\n    # Connect to the serial port\n    ser = serial.Serial(serial_port, baudrate, timeout=1)\n\n    # List to store responses\n    responses = &#91;]\n\n    # Send the command 'AT+CENTRAL' to the device\n    ser.write(b\"AT+CENTRAL\\r\")\n    response = read_response(ser)\n\n    # Connect to the device\n    ser.write(b\"AT+GAPCONNECT=&#91;1]D1:53:C9:A9:8C:D2\\r\")\n    response = read_response(ser)\n\n    # Set notification\n    ser.write(b\"AT+SETNOTI=0021\\r\")\n    response = read_response(ser)\n\n    # Get all data\n    ser.write(b\"AT+GATTCWRITEWR=0021 GET DATA=ALL\\r\")\n    while True:\n        response = read_response(ser)\n        responses.append(response.strip())\n        if \"DATA:END\" in response:\n            break  # End of response\n\n    # Find and collect patterns matching the specified format\n    collected_patterns = &#91;]\n    for r in responses:\n        pattern_matches = find_pattern(r)\n        if pattern_matches:\n            collected_patterns.extend(pattern_matches)\n\n    # Convert to JSON\n    json_data = json.dumps(collected_patterns, indent=2)\n    print(json_data)\n\n    # Close the serial port\n    ser.close()\n\n\nif __name__ == \"__main__\":\n    main()\n<\/code><\/pre>\n\n\n\n<p>In this code we have <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Establishes a connection to the serial port, sends commands to the BLE device, and retrieves responses of 7 days air quality data history stored in the device.<\/li>\n\n\n\n<li>Parses the responses to extract relevant patterns using regular expressions.<\/li>\n\n\n\n<li>Converts the extracted patterns into JSON format for easy handling and printing.<\/li>\n\n\n\n<li>Finally, closes the serial port.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Integrating with Excel<\/h3>\n\n\n\n<p>Now, let&#8217;s integrate BleuIO with Excel to visualize and analyze the air quality data. By executing a Python script within Excel&#8217;s VBA environment, we can populate the data directly into Excel for further analysis.<\/p>\n\n\n\n<p>Here is the complete code <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub SerialCommunication()\n    Dim response As String\n    Dim pythonScriptPath As String\n    Dim wsh As Object, exec As Object, output As String\n    Dim jsonData As Object\n    Dim obj As Object\n    Dim i As Integer, j As Integer\n    \n    ' Set the path to the Python script\n    pythonScriptPath = \"C:\\Users\\PC\\Desktop\\excel bleuio\\serial_communication.py\" ' Update with the correct path\n    \n    ' Create Windows Script Host object\n    Set wsh = CreateObject(\"WScript.Shell\")\n    \n    ' Execute the Python script and capture its output\n    Set exec = wsh.exec(\"python \"\"\" &amp; pythonScriptPath &amp; \"\"\"\")\n    \n    ' Read the output of the script\n    output = exec.StdOut.ReadAll\n    \n    ' Parse JSON data\n    Set jsonData = JsonConverter.ParseJson(output)\n    \n    ' Write headers in the first row\n    i = 1 ' Starting row\n    j = 1 ' Starting column\n    For Each key In jsonData(1).Keys\n        Sheet1.Cells(i, j).value = key\n        j = j + 1\n    Next key\n    \n    ' Write data into separate columns\n    i = i + 1 ' Move to the next row\n    For Each obj In jsonData\n        j = 1 ' Starting column\n        For Each key In obj.Keys\n            Sheet1.Cells(i, j).value = obj(key)\n            j = j + 1\n        Next key\n        i = i + 1 ' Move to the next row\n    Next obj\nEnd Sub\n<\/code><\/pre>\n\n\n\n<p>In this code we have,<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Called the python script. <\/li>\n\n\n\n<li>The response we got from python script we then passed it using JsonConverter. <\/li>\n\n\n\n<li>Finally we loop through the object and presented it on the Excel sheet on their respective cells. <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><br>Set up JsonConverter<\/h3>\n\n\n\n<p>If you get error like JsonConverter object is not recognized, follow the steps: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Download JSONConverter.bas<\/strong>: You can download the <code>JSONConverter.bas<\/code> file from various sources online. Here is a good github link to download from. <br>https:\/\/github.com\/VBA-tools\/VBA-JSON<br>It&#8217;s a common utility module for VBA that provides JSON parsing capability.<\/li>\n\n\n\n<li><strong>Import JSONConverter.bas into your project<\/strong>: Open your Excel workbook, then go to the Visual Basic Editor (Alt + F11). From the menu, select <code>File > Import File<\/code> and choose the <code>JSONConverter.bas<\/code> file you downloaded. This will add the <code>JSONConverter<\/code> module to your project.<\/li>\n\n\n\n<li><strong>Ensure Microsoft Scripting Runtime Reference<\/strong>: Go to <code>Tools > References<\/code> in the VBA editor and ensure that &#8220;Microsoft Scripting Runtime&#8221; is checked. This is needed for dictionary objects used in JSON parsing.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Run the script<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Insert a Button<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Go to the &#8220;Developer&#8221; tab in Excel. If you don&#8217;t see the &#8220;Developer&#8221; tab, you may need to enable it in Excel options.<\/li>\n\n\n\n<li>Click on the &#8220;Insert&#8221; drop-down menu in the &#8220;Controls&#8221; group.<\/li>\n\n\n\n<li>Choose the &#8220;Button&#8221; (Form Control) option.<\/li>\n\n\n\n<li>Click and drag to draw the button on your worksheet.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Assign the Macro<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Right-click on the button you just inserted and select &#8220;Assign Macro&#8221;.<\/li>\n\n\n\n<li>In the &#8220;Assign Macro&#8221; dialog box, you should see a list of available macros. Since you just created a new macro, it should be listed. In this case, it should be &#8220;SerialCommunication&#8221;.<\/li>\n\n\n\n<li>Select the &#8220;SerialCommunication&#8221; macro and click &#8220;OK&#8221;.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Edit the Macro (if needed)<\/strong>:\n<ul class=\"wp-block-list\">\n<li>If you want to edit the macro, you can click on the &#8220;Edit&#8221; button in the &#8220;Assign Macro&#8221; dialog box. This will open the VBA editor where you can make changes to the macro.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Test the Button<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Click on the button you inserted in your worksheet. This should trigger the &#8220;SerialCommunication&#8221; macro, which will execute the VBA code to communicate with the serial port and display the response in Excel.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Ensure Correct Port and Settings<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Before testing, ensure that the COM port (COM8) and other settings in the VBA code match your requirements and device specifications.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Output<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"752\" height=\"971\" src=\"https:\/\/www.bleuio.com\/blog\/wp-content\/uploads\/2024\/04\/image-12.png\" alt=\"\" class=\"wp-image-655\" srcset=\"https:\/\/www.bleuio.com\/blog\/wp-content\/uploads\/2024\/04\/image-12.png 752w, https:\/\/www.bleuio.com\/blog\/wp-content\/uploads\/2024\/04\/image-12-232x300.png 232w\" sizes=\"auto, (max-width: 752px) 100vw, 752px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"720\" style=\"aspect-ratio: 1280 \/ 720;\" width=\"1280\" controls src=\"https:\/\/www.bleuio.com\/blog\/wp-content\/uploads\/2024\/04\/BleuIO-Bluetooth-Low-Energy-BLE-USB-Dongle.mp4\"><\/video><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Use Cases: Transforming Data into Actionable Insights<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/www.hibouair.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Indoor Air Quality Monitoring<\/a><\/strong>: Deploy BLE-enabled sensors in indoor environments to monitor air quality parameters such as temperature, humidity, and particulate matter. Excel&#8217;s data analysis capabilities enable users to identify trends, anomalies, and potential air quality issues, facilitating proactive measures for improving indoor air quality.<\/li>\n\n\n\n<li><strong>Environmental Studies and Research<\/strong>: Conduct environmental studies and research projects using BleuIO to collect air quality data in various outdoor settings. Excel serves as a powerful tool for data aggregation, statistical analysis, and visualization, enabling researchers to gain valuable insights into environmental patterns and trends.<\/li>\n\n\n\n<li><strong>Health and Safety Compliance<\/strong>: Ensure compliance with health and safety regulations by monitoring air quality in workplaces, public spaces, and industrial facilities. BleuIO, coupled with Excel, enables continuous monitoring of air quality parameters, facilitating compliance reporting and risk assessment processes.<\/li>\n<\/ol>\n\n\n\n<p>By leveraging BleuIO&#8217;s seamless BLE communication capabilities and Excel&#8217;s robust data analysis features, developers and analysts can unlock the full potential of BLE application development and data analysis. Whether you&#8217;re monitoring air quality in indoor environments, conducting environmental research, or ensuring regulatory compliance, BleuIO and Excel provide a powerful combination for transforming raw data into actionable insights.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In today&#8217;s data-driven world, extracting meaningful insights from raw data is crucial for informed decision-making. Microsoft Excel stands as an amazing tool for data analysis, offering powerful features for visualization, manipulation, and interpretation. However, accessing and processing data from external sources, such as BLE devices, can often be challenging and time-consuming. BleuIO revolutionizes BLE application [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":908,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,2],"tags":[],"class_list":["post-654","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bleuio","category-bleuio-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Reading data from BLE device using Python, Microsoft Excel and BleuIO - BleuIO - Create Bluetooth Low Energy application<\/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.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reading data from BLE device using Python, Microsoft Excel and BleuIO - BleuIO - Create Bluetooth Low Energy application\" \/>\n<meta property=\"og:description\" content=\"In today&#8217;s data-driven world, extracting meaningful insights from raw data is crucial for informed decision-making. Microsoft Excel stands as an amazing tool for data analysis, offering powerful features for visualization, manipulation, and interpretation. However, accessing and processing data from external sources, such as BLE devices, can often be challenging and time-consuming. BleuIO revolutionizes BLE application [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/\" \/>\n<meta property=\"og:site_name\" content=\"BleuIO - Create Bluetooth Low Energy application\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-17T21:08:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-19T15:51:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bleuio.com\/blog\/wp-content\/uploads\/2024\/04\/excel-python-bluetooth.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"BleuIO\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/\"},\"author\":{\"name\":\"BleuIO\",\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/#\\\/schema\\\/person\\\/89bc581382d5964043f96efc54b75b80\"},\"headline\":\"Reading data from BLE device using Python, Microsoft Excel and BleuIO\",\"datePublished\":\"2024-04-17T21:08:19+00:00\",\"dateModified\":\"2024-09-19T15:51:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/\"},\"wordCount\":963,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/excel-python-bluetooth.jpg\",\"articleSection\":[\"BleuIO\",\"BleuIO tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/\",\"url\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/\",\"name\":\"Reading data from BLE device using Python, Microsoft Excel and BleuIO - BleuIO - Create Bluetooth Low Energy application\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/excel-python-bluetooth.jpg\",\"datePublished\":\"2024-04-17T21:08:19+00:00\",\"dateModified\":\"2024-09-19T15:51:50+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/#\\\/schema\\\/person\\\/89bc581382d5964043f96efc54b75b80\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/excel-python-bluetooth.jpg\",\"contentUrl\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/excel-python-bluetooth.jpg\",\"width\":800,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reading data from BLE device using Python, Microsoft Excel and BleuIO\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/\",\"name\":\"BleuIO - Create Bluetooth Low Energy application\",\"description\":\"Learn Bluetooth Low Energy programming and build Bluetooth Low Energy Application\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/#\\\/schema\\\/person\\\/89bc581382d5964043f96efc54b75b80\",\"name\":\"BleuIO\",\"sameAs\":[\"https:\\\/\\\/www.bleuio.com\\\/blog\"],\"url\":\"https:\\\/\\\/www.bleuio.com\\\/blog\\\/author\\\/biadmin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reading data from BLE device using Python, Microsoft Excel and BleuIO - BleuIO - Create Bluetooth Low Energy application","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.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/","og_locale":"en_US","og_type":"article","og_title":"Reading data from BLE device using Python, Microsoft Excel and BleuIO - BleuIO - Create Bluetooth Low Energy application","og_description":"In today&#8217;s data-driven world, extracting meaningful insights from raw data is crucial for informed decision-making. Microsoft Excel stands as an amazing tool for data analysis, offering powerful features for visualization, manipulation, and interpretation. However, accessing and processing data from external sources, such as BLE devices, can often be challenging and time-consuming. BleuIO revolutionizes BLE application [&hellip;]","og_url":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/","og_site_name":"BleuIO - Create Bluetooth Low Energy application","article_published_time":"2024-04-17T21:08:19+00:00","article_modified_time":"2024-09-19T15:51:50+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/www.bleuio.com\/blog\/wp-content\/uploads\/2024\/04\/excel-python-bluetooth.jpg","type":"image\/jpeg"}],"author":"BleuIO","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/#article","isPartOf":{"@id":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/"},"author":{"name":"BleuIO","@id":"https:\/\/www.bleuio.com\/blog\/#\/schema\/person\/89bc581382d5964043f96efc54b75b80"},"headline":"Reading data from BLE device using Python, Microsoft Excel and BleuIO","datePublished":"2024-04-17T21:08:19+00:00","dateModified":"2024-09-19T15:51:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/"},"wordCount":963,"commentCount":0,"image":{"@id":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bleuio.com\/blog\/wp-content\/uploads\/2024\/04\/excel-python-bluetooth.jpg","articleSection":["BleuIO","BleuIO tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/","url":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/","name":"Reading data from BLE device using Python, Microsoft Excel and BleuIO - BleuIO - Create Bluetooth Low Energy application","isPartOf":{"@id":"https:\/\/www.bleuio.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/#primaryimage"},"image":{"@id":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bleuio.com\/blog\/wp-content\/uploads\/2024\/04\/excel-python-bluetooth.jpg","datePublished":"2024-04-17T21:08:19+00:00","dateModified":"2024-09-19T15:51:50+00:00","author":{"@id":"https:\/\/www.bleuio.com\/blog\/#\/schema\/person\/89bc581382d5964043f96efc54b75b80"},"breadcrumb":{"@id":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/#primaryimage","url":"https:\/\/www.bleuio.com\/blog\/wp-content\/uploads\/2024\/04\/excel-python-bluetooth.jpg","contentUrl":"https:\/\/www.bleuio.com\/blog\/wp-content\/uploads\/2024\/04\/excel-python-bluetooth.jpg","width":800,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/www.bleuio.com\/blog\/reading-data-from-ble-device-using-microsoft-excel-and-bleuio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bleuio.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Reading data from BLE device using Python, Microsoft Excel and BleuIO"}]},{"@type":"WebSite","@id":"https:\/\/www.bleuio.com\/blog\/#website","url":"https:\/\/www.bleuio.com\/blog\/","name":"BleuIO - Create Bluetooth Low Energy application","description":"Learn Bluetooth Low Energy programming and build Bluetooth Low Energy Application","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bleuio.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.bleuio.com\/blog\/#\/schema\/person\/89bc581382d5964043f96efc54b75b80","name":"BleuIO","sameAs":["https:\/\/www.bleuio.com\/blog"],"url":"https:\/\/www.bleuio.com\/blog\/author\/biadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/posts\/654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/comments?post=654"}],"version-history":[{"count":2,"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/posts\/654\/revisions"}],"predecessor-version":[{"id":906,"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/posts\/654\/revisions\/906"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/media\/908"}],"wp:attachment":[{"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/media?parent=654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/categories?post=654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bleuio.com\/blog\/wp-json\/wp\/v2\/tags?post=654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}