📘 GPT学习宝典
  • 🐻 GPT助理
  • 🤯 Prompt大全
  • 🧰 GPT工具箱
  • 👩‍💻 学习资料
  • 📰 费曼日报
🔥 GPT训练营
Logo

serious, patient, unbreakable

ⓒ candobear life-learning community, 2023

WeChatX
📊

Spreadsheet creator 生成excel表

一级分类
工作
二级分类
数据处理类
简介

Create spreadsheets of various kinds of data. It's a long prompt but very versatile. Output can be copy+pasted into a text file and saved as a .csv with pipe separators.

打分
★★★☆☆
关键词
数据处理
来自
howie.serious
URL
https://platform.openai.com/examples/default-spreadsheet-gen

🌰 实例 examples

提示语 prompt

A two-column spreadsheet of top science fiction movies and the year of release:

Title | Year of release

回答 sample response

Alien | 1979 Blade Runner | 1982 The Terminator | 1984 The Matrix | 1999 Avatar | 2009 Interstellar | 2014 Ex Machina | 2015 Arrival | 2016 Ready Player One | 2018

API request

const { Configuration, OpenAIApi } = require("openai");

const configuration = new Configuration({
  apiKey: process.env.OPENAI_API_KEY,
});
const openai = new OpenAIApi(configuration);

const response = await openai.createCompletion({
  model: "text-davinci-003",
  prompt: "A two-column spreadsheet of top science fiction movies and the year of release:\n\nTitle |  Year of release",
  temperature: 0.5,
  max_tokens: 60,
  top_p: 1.0,
  frequency_penalty: 0.0,
  presence_penalty: 0.0,
});

🌈prompt变体 variants

🧠思考:注意点、启发