heshengtao / comfyui_LLM_party

LLM Agent Framework in ComfyUI includes Omost,GPT-sovits, ChatTTS,GOT-OCR2.0, and FLUX prompt nodes,access to Feishu,discord,and adapts to all llms with similar openai/gemini interfaces, such as o1,ollama, grok, qwen, GLM, deepseek, moonshot,doubao. Adapted to local llms, vlm, gguf such as llama-3.2, Linkage neo4j KG, graphRAG / RAG / html 2 img
GNU Affero General Public License v3.0
1.05k stars 93 forks source link

Excel Parsing of info from columns #68

Closed boricuapab closed 2 months ago

boricuapab commented 3 months ago

Is your feature request related to a problem? Please describe. How to select the prompt and suffix from column A and B from an excel sheet and concatenate them?

Describe the solution you'd like When queueing a specified line and column should be concatenated into a prompt without these kinds of tokens ({}:")

ex: {"Prompt": "deer", "Suffix": "high quality"}

Should result in:

deer, high quality

Describe alternatives you've considered I've used used a few WAS nodes to do search and replace and concat, but it gets messy with alot of nodes needed

Additional context Here's a gif showing what I mean

llmpartyexcel

boricuapab commented 3 months ago

All good, works with json get node

jsonGetFix

boricuapab commented 3 months ago

Actually, is it possible to pick a specific row from the excel sheet, say I want to use row 2, then later row 4, then lastly row 3?

heshengtao commented 3 months ago

Add a load_all attribute to this node, and then you can use json get to get any element in the large list, for example, line 0 is to enter 0 屏幕截图 2024-08-16 141141