マインドマップギャラリー DeepSeekを接続してデータ分析のためにExcel(スクリプトを使用)
これは、データ分析のためにDeepSeekをExcelに接続する方法に関するマインドマップです。
2025-02-06 10:14:57 に編集されましたRumi: 10 dimensions of spiritual awakening. When you stop looking for yourself, you will find the entire universe because what you are looking for is also looking for you. Anything you do persevere every day can open a door to the depths of your spirit. In silence, I slipped into the secret realm, and I enjoyed everything to observe the magic around me, and didn't make any noise. Why do you like to crawl when you are born with wings? The soul has its own ears and can hear things that the mind cannot understand. Seek inward for the answer to everything, everything in the universe is in you. Lovers do not end up meeting somewhere, and there is no parting in this world. A wound is where light enters your heart.
Chronic heart failure is not just a problem of the speed of heart rate! It is caused by the decrease in myocardial contraction and diastolic function, which leads to insufficient cardiac output, which in turn causes congestion in the pulmonary circulation and congestion in the systemic circulation. From causes, inducement to compensation mechanisms, the pathophysiological processes of heart failure are complex and diverse. By controlling edema, reducing the heart's front and afterload, improving cardiac comfort function, and preventing and treating basic causes, we can effectively respond to this challenge. Only by understanding the mechanisms and clinical manifestations of heart failure and mastering prevention and treatment strategies can we better protect heart health.
Ischemia-reperfusion injury is a phenomenon that cellular function and metabolic disorders and structural damage will worsen after organs or tissues restore blood supply. Its main mechanisms include increased free radical generation, calcium overload, and the role of microvascular and leukocytes. The heart and brain are common damaged organs, manifested as changes in myocardial metabolism and ultrastructural changes, decreased cardiac function, etc. Prevention and control measures include removing free radicals, reducing calcium overload, improving metabolism and controlling reperfusion conditions, such as low sodium, low temperature, low pressure, etc. Understanding these mechanisms can help develop effective treatment options and alleviate ischemic injury.
Rumi: 10 dimensions of spiritual awakening. When you stop looking for yourself, you will find the entire universe because what you are looking for is also looking for you. Anything you do persevere every day can open a door to the depths of your spirit. In silence, I slipped into the secret realm, and I enjoyed everything to observe the magic around me, and didn't make any noise. Why do you like to crawl when you are born with wings? The soul has its own ears and can hear things that the mind cannot understand. Seek inward for the answer to everything, everything in the universe is in you. Lovers do not end up meeting somewhere, and there is no parting in this world. A wound is where light enters your heart.
Chronic heart failure is not just a problem of the speed of heart rate! It is caused by the decrease in myocardial contraction and diastolic function, which leads to insufficient cardiac output, which in turn causes congestion in the pulmonary circulation and congestion in the systemic circulation. From causes, inducement to compensation mechanisms, the pathophysiological processes of heart failure are complex and diverse. By controlling edema, reducing the heart's front and afterload, improving cardiac comfort function, and preventing and treating basic causes, we can effectively respond to this challenge. Only by understanding the mechanisms and clinical manifestations of heart failure and mastering prevention and treatment strategies can we better protect heart health.
Ischemia-reperfusion injury is a phenomenon that cellular function and metabolic disorders and structural damage will worsen after organs or tissues restore blood supply. Its main mechanisms include increased free radical generation, calcium overload, and the role of microvascular and leukocytes. The heart and brain are common damaged organs, manifested as changes in myocardial metabolism and ultrastructural changes, decreased cardiac function, etc. Prevention and control measures include removing free radicals, reducing calcium overload, improving metabolism and controlling reperfusion conditions, such as low sodium, low temperature, low pressure, etc. Understanding these mechanisms can help develop effective treatment options and alleviate ischemic injury.
DeepSeekを接続してデータ分析のためにExcelを接続する方法 (添付のスクリプト)
DeepseekをExcelに接続します
1. 1. DeepSeek APIを取得します
権限を確保します
:DeepSeek APIへのアクセスを取得します。
APIキーを取得します
:認証に使用。
2. 2。Excelを使用した電源クエリ
ステップ
1. オープンパワークエリ
Excelの「データ」タブに移動します。
[他のソースからデータを取得]> [Web]から[取得]を選択します。
2. APIリクエストを構成します
DeepSeek APIのURLを入力します。
リクエストヘッダー(APIキーなど)を追加する詳細オプションを選択します。
3. APIを呼び出します
[OK]をクリックすると、電源クエリがAPIを呼び出してデータを返します。
4. データの読み込み
分析のためにデータをExcelにロードします。
3. 3. VBAスクリプトを使用します
VBAエディターを開きます
Alt F11を押します
VBAエディターを開きます。
新しいモジュールを挿入します。
VBAコードの作成
サンプルコード:
Sub CallDeepSeekapi()dim http as object dim url as string dim apikey as string dim response as string url = "https://api.deepseek.com/your-endpoint" apikey = "your_api_key_here" set http = createObject( "msxml2。 xmlhttp ")http.open" get "、url、false http.setRequestheader" authorization "、" Bearer "&apikey http.send response = http.responsetext 'JSONの解析やExcel End Subへの書き込みなど、プロセス応答
スクリプトを実行します
APIを呼び出して、結果を記述してExcelにします。
4. 4. Excelプラグインを使用します
適用可能なシナリオ
:API統合をサポートする既製のプラグインがある場合。
ステップ
1. API呼び出しをサポートするExcelプラグインをインストールします。
2. DeepSeek APIのURLとキーを構成します。
3. プラグインを介してAPIを直接呼び出して、データを取得します。
5. 5。データの処理と分析
道具
ピボットテーブル。
チャート関数。
ターゲット
取得したデータの詳細な分析を実行します。
6. 注意すべきこと
APIの制限
通話頻度とデータのボリューム制限に注意してください。
データセキュリティ
漏れを避けるために、APIキーを保護します。
要約します
電源クエリ
:単純なAPI呼び出しとデータの読み込みに適しています。
VBAスクリプト
:複雑なシナリオと高い柔軟性に適しています。
Excelプラグイン
:迅速な統合に適していますが、プラグイン機能に依存しています。
説明します
マップ製造ツール:マインドマスター、製造:空のティーカップ